Date Time Functions MySQL Tutorial

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