var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Adding 7 days to a date
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'
look at the dateadd function
It seems as if your timestamp field might be a varchar so you might also need to use the convert function to convert to datetime