Adding 7 days to a date
Posted by:
Anjel
Date: January 31, 2007 04:27PM
I am trying to remove data from a table in a database. Like a sort of archiving processes whereby I remove one week of data at a time.
So I select the min date from the table (select min (TIMESTAMP) from <tblname>)
Which returns a date in the following format -> 20070114 13:22:59.843671 +0000?
I want to be able to add seven days to that field so I will end up with 20070121
And then I can delete from table name where TIMESTAMP < '20070121'
Any suggestions?
Thanks
Anjel
Subject
Views
Written By
Posted
Adding 7 days to a date
49417
January 31, 2007 04:27PM
79261
January 31, 2007 05:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.