Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

Getting a date 6 months in the past

mysql> mysql> SELECT DATE_SUB(CURDATE(), INTERVAL 6 MONTH); +---------------------------------------+ | DATE_SUB(CURDATE(), INTERVAL 6 MONTH) | +---------------------------------------+ | 2007-01-21                            | +---------------------------------------+ 1 row in set (0.00 sec) mysql>