CODE EXAMPLE FOR SQL

how to delete a database record after a certain time

DELETE messages WHERE date < DATE_SUB(NOW(), INTERVAL 7 DAY);