Select * to table where datetime is 24 hours ago.

Question

I need to select all data in table created not less than 24 hours ago. Anyone know how to do this?

Answer 1

Depends on your database. Look up the date math functions e.g. datediff and date_sub in your help files.

Answer 2

Assuming your table has a DATETIME field, in this example called date_field

SELECT * FROM tablename WHERE date_field <= SUBDATE( CURRENT_DATE, INTERVAL 24 HOUR)

OR

SELECT * FROM tablename WHERE date_field > NOW() - interval 1 day