SQL - Delete all Records older than specified Date or Time
Posted: Wed May 08, 2024 3:45 pm
MY SQL
30 Days
1 Month
MS SQL Server
30 Days
1 Month
30 Days
Code: Select all
DELETE FROM <table_name> where <Date Field> < now() - INTERVAL 30 DAY;Code: Select all
DELETE FROM <table_name> where <Date Field> < now() - INTERVAL 1 MONTH;30 Days
Code: Select all
DELETE FROM <table_name> WHERE date < DATEADD(day, -30, GETDATE())Code: Select all
DELETE FROM <table_name> WHERE date < DATEADD(MONTH, -5, GETDATE()