SQL check if timestamp is greater than 24 hours from now (MYSQL)

Question

How to check if timestamp is greater than 24 hours from now with mysql?

DELETE FROM `users` WHERE `time` = ?

Update: date format — 2013-10-24 13:33:23

Answer 1

Try out this Query:

SELECT * FROM news WHERE date >= now() + INTERVAL 1 DAY;

Feel free to ask

Answer 2

try this:

DELETE FROM `users` WHERE `time` >= (NOW() + INTERVAL 1 DAY);

or try this:

DELETE FROM `users` WHERE `time` >= DATE_SUB(CURDATE(),INTERVAL 1 DAY);

or try this:

DELETE FROM `users` WHERE `time` >=  curdate() + interval 1 day

here is a link with some function mysql to manage time
DOCUMENTATION