CODEWITHSUNDEEP
mysqldatetime
luca
luca

Reputation: 37136

mysql adding hours to datetime

In MYSQL DB I need to check if a "datetime" field is more than 24hours (or whatever) ago in which case delete the row.

How to add hours to datetime in mysql?

thanks

Luca

Upvotes: 29

Views: 64103

Answers (4)

Maxime Pacary
Maxime Pacary

Reputation: 23061

DELETE 
FROM table 
WHERE datetime_field < DATE_SUB(NOW(), INTERVAL 1 DAY);

Upvotes: 0

Muhamad Bhaa Asfour
Muhamad Bhaa Asfour

Reputation: 1035

there is the addtime() method in mysql

Upvotes: 3

Pascal MARTIN
Pascal MARTIN

Reputation: 401032

What about something like this :

delete
from your_table
where your_field <= date_sub(now(), INTERVAL 1 day)


With :


Or, if you want o use 24 hours instead of 1 day :

delete
from your_table
where your_field <= date_sub(now(), INTERVAL 24 hour)

Upvotes: 43

Alin P.
Alin P.

Reputation: 44346

You have the Date and Time functions.

WHERE `yourDate` < DATE_SUB(NOW(),INTERVAL 1 DAY)

or shorter

WHERE `yourDate` < NOW() - INTERVAL 1 DAY

Upvotes: 13

Related Questions