CODE EXAMPLE FOR SQL

check records older than 10 days

SELECT * FROM photo WHERE DATE(date_created) < DATE_SUB(CURDATE(), INTERVAL 10 DAY);