Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SUBDATE(expr,days)
mysql>
mysql> SELECT SUBDATE('1998-01-02 12:00:00', 31);
+------------------------------------+
| SUBDATE('1998-01-02 12:00:00', 31) |
+------------------------------------+
| 1997-12-02 12:00:00                |
+------------------------------------+
1 row in set (0.00 sec)
mysql>