Geçmiş Tarih İşlemleri

Geçen Yıl:

SELECT * FROM table WHERE YEAR(date_created) = YEAR(CURRENT_DATE - INTERVAL 1 YEAR);

Geçen Ay:

SELECT * FROM table WHERE MONTH(date_created) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH);

Geçen Hafta:

SELECT * FROM table WHERE WEEK(date_created) = WEEK(CURRENT_DATE - INTERVAL 1 WEEK);

Geçen Gün:

SELECT * FROM table WHERE DAY(date_created) = DAY(CURRENT_DATE - INTERVAL 1 DAY);

Veya şu kodları da kullanabilirsiniz:

SELECT * FROM table WHERE date_created <= NOW() - INTERVAL 1 YEAR;
SELECT * FROM table WHERE date_created <= NOW() - INTERVAL 1 MONTH;
SELECT * FROM table WHERE date_created <= NOW() - INTERVAL 1 WEEK;
SELECT * FROM table WHERE date_created <= NOW() - INTERVAL 1 DAY;