CODE EXAMPLE FOR SQL

mysql date greater than 30 days

SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)