Delete from a table based on date

Question

Can anyone help me with the script which will delete the data older than the particular date   Thanks

User · Answer

You could use   DELETE FROM tableName where your date column  lt   2009-01-01     but Keep in mind that the above is really   DELETE FROM tableName     where your date column  lt   2009-01-01 00 00 00     Not   DELETE FROM tableName         where your date column  lt   2009-01-01 11 59

User · Answer

delete from YOUR TABLE where your date column  lt   2009-01-01     This will delete rows from YOUR TABLE where the date in your date column is older than January 1st  2009  i e  a date with 2008-12-31 would be deleted

User · Answer

or an ORACLE version   delete   from table name  where trunc table name date   gt  to date  01 01 2009   mm dd yyyy

User · Answer

This is pretty vague  Do you mean like in SQL   DELETE FROM myTable WHERE dateColumn  lt   2007

User · Answer

Delete data that is 30 days and older     DELETE FROM Table    WHERE DateColumn  lt  GETDATE  - 30

[sql-server] Delete from a table based on date

Examples related to sql-server