Example’s that uses date functions.
The following query selects all rows with a date_col value from within the last 30 days:
mysql> SELECT something FROM tbl_name
-> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;
ADDDATE(, date,INTERVAL expr unit)ADDDATE(expr,days)
SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY);
-> ‘2008-02-02′
SELECT ADDDATE(‘2008-01-02′, INTERVAL 31 DAY);
-> ‘2008-02-02′
mysql> SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');
-> ‘Sunday October 2009′
mysql> SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s');
-> ‘22:23:00′
mysql> SELECT DATE_FORMAT('1900-10-04 22:23:00',
-> '%D %y %a %d %m %b %j');
-> ‘4th 00 Thu 04 10 Oct 277′
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00',
-> '%H %k %I %r %T %S %w');
-> ‘22 22 10 10:23:00 PM 22:23:00 00 6′
mysql> SELECT DATE_FORMAT('1999-01-01', '%X %V');
-> ‘1998 52′
mysql> SELECT DATE_FORMAT('2006-06-00', '%d');
-> ‘00′
mysql> SELECT EXTRACT(YEAR FROM '2009-07-02');
-> 2009
mysql> SELECT EXTRACT(YEAR_MONTH FROM '2009-07-02 01:02:03');
-> 200907
mysql> SELECT EXTRACT(DAY_MINUTE FROM '2009-07-02 01:02:03');
-> 20102
mysql> SELECT EXTRACT(MICROSECOND
-> FROM '2003-01-02 10:30:00.000123');
-> 123
