View previous topic :: View next topic
|
Author |
Message |
srikanthdv
New User
Joined: 17 Mar 2006 Posts: 5 Location: pune
|
|
|
|
HI,
We have a requirement to update the Last Updated Timestamp prior to 60 days from current Timestamp.
For example, if the value in the Last updated Timestamp column in the table is 2006-06-16-08.17.49.798804 then we need to update it like
2006-08-22-10.13.39.756894 becuse we are Substracting 60 days from current timestamp(2006-10-21-10.13.39.756894).
We have nothing to do with the value present in the Last Update Timestamp column in the table.
Whatever the value may be in the Last Updated Timestamp column we need to update it with substracting 60 days from cureent timestamp.(ie.. Current Run Time)..
Pelase let me know if any one needs more info..
Awaiting for your Reply.. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
Please check if it works
Code: |
update table1
set Last updated Timestamp =Last updated Timestamp - 60 days. |
please let us know the result |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
A little miss understanding...
Code: |
UPDATE TABLE1
SET LAST_UPDATED_TIMESTAMP = CURRENT TIMESTAMP - 60 DAYS; |
|
|
Back to top |
|
|
|