Mega Code Archive

 

Categories / MySQL / Date Time

 

Get sub date

/* mysql> SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY); +------------------------------------+ | DATE_SUB(CURDATE(),INTERVAL 1 DAY) | +------------------------------------+ | 2005-10-08                         | +------------------------------------+ 1 row in set (0.00 sec) */   SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY);