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);
Related examples in the same category