Date Time Functions MySQL Tutorial

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