Maybe try something like ....

Update <Table Name>
set <Colane> =
cast('**NewDateValue**'||substr(Char(<Colane>),11,16) as
timestamp)
where
<Your Specific Criteria that identifies the 1000 rows>



William B. Gannon
- IBM Certified Solutions Expert
- IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS


-----Original Message-----
From: Naravula Ramesh
[mailto:db2udbdba-ezmlmshield-x72369811.[Email address protected]
Sent: Tuesday, October 23, 2007 8:29 AM
To: LazyDBA Discussion
Subject: Date part needs to change in Timestamp

Hi,

I have to update date part alone in timestamp column for 1000 rows.
Can you please suggest me how to do it in Db2 for Z/os.

regards
Ramesh



************************************************************************
****
The content of this email is intended only for the confidential use of
the
person addressed. If you have received this message in error, please
notify
us immediately.

Email communications are not secure, and therefore we do not accept any
res-
ponsibility for the confidentiality or altered contents of this message.

The views expressed above are not necessarily those held by the SIS
Group
and its subsidiary companies.
************************************************************************
****



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

-----------------------------------------
Under Florida law, e-mail addresses are public records. If you do
not want your e-mail address released in response to a public
records request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.

DB2 & UDB email list listserv db2-l LazyDBA home page