Comparing dates in SQL

Just a quick code snippet that returns all rows whose date field is older than two days ago:

SELECT * FROM tablename WHERE datecolumn < DATE_SUB(CURDATE(); INTERVAL 2 DAY)

Wednesday, 1st April 2009» Permalink.

Tagged: