Mega Code Archive

 

Categories / MySQL / Date Time

 

Find the date a week ago

mysql> mysql> SELECT CURDATE( ), DATE_SUB(CURDATE( ),INTERVAL 7 DAY); +------------+-------------------------------------+ | CURDATE( ) | DATE_SUB(CURDATE( ),INTERVAL 7 DAY) | +------------+-------------------------------------+ | 2011-10-03 | 2011-09-26                          | +------------+-------------------------------------+ 1 row in set (0.00 sec) mysql>