Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. SUBDATE(date, days) allows you to subtract a specified number of days from a date
mysql>
mysql>
mysql> SELECT SUBDATE('2004-12-31 23:59:59', 31);
+------------------------------------+
| SUBDATE('2004-12-31 23:59:59', 31) |
+------------------------------------+
| 2004-11-30 23:59:59                |
+------------------------------------+
1 row in set (0.00 sec)