EvB

Comparing dates in SQL

1st April 2009

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)