IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need to update the date value alone
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
mutvijayan

New User


Joined: 22 Nov 2010
Posts: 3
Location: Chennai
PostPosted: Thu Nov 25, 2010 1:06 pm
 Reply with quote
Hi All!

I have one field with the TIMESTAMP datatype in a table. But, i need to update the date value alone. Can anyone tell me how to do it?

Regards,
M.Vijayan
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Thu Nov 25, 2010 1:48 pm
 Reply with quote
UPDATE table
SET TIMESTAMP_COLUMN = TIMESTAMP_COLUMN + 4 DAYS

or - 2 years
or + 6 hours
or
or
or
or
or
Back to top
View user's profile Send private message
mutvijayan

New User


Joined: 22 Nov 2010
Posts: 3
Location: Chennai
PostPosted: Thu Nov 25, 2010 2:20 pm
 Reply with quote
Thank you very much.. It's working.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Need help to append a date&tsp at... DFSORT/ICETOOL 9
No new posts Fetch data from programs execute (dat... DB2 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us