delete data from database where date ... SQL

Question

hey

I want to delete some data from database:

WHERE created_at < NOW() - 30 min

How to wirte the 30 min into sql

Answer 1

Calculate older date and compare with it:

WHERE created_at < NOW() - INTERVAL 30 MINUTE

See DATE_ADD description for list of all available units.

Answer 2

WHERE created_at < NOW() - INTERVAL 30 MINUTE;