MySQL Forums
Forum List  »  Sybase

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

Options: ReplyQuote


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.