Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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);