delete data from database where date ... SQL

Question

I want to delete some data from database:

WHERE created_at < NOW() - 30 min

How to wirte the 30 min into sql

Ivan Nevostruev · Accepted Answer · 2009-12-06 15:11:10Z

4

Calculate older date and compare with it:

WHERE created_at < NOW() - INTERVAL 30 MINUTE

See DATE_ADD description for list of all available units.

answered Dec 6, 2009 at 15:05

Ivan Nevostruev

28.9k8 gold badges69 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mobs · Accepted Answer · 2009-12-06 15:07:15Z

1

WHERE created_at < NOW() - INTERVAL 30 MINUTE;

answered Dec 6, 2009 at 15:07

Mobs

1,57213 silver badges17 bronze badges