Comparing dates in SQL
Just a quick code snippet that returns all rows whose date field is older than two days ago
SELECT * FROM table_name WHERE date_column < DATE_SUB(CURDATE(); INTERVAL 2 DAY)
Just a quick code snippet that returns all rows whose date field is older than two days ago
SELECT * FROM table_name WHERE date_column < DATE_SUB(CURDATE(); INTERVAL 2 DAY)