Date arithmetic also can be performed using INTERVAL together with the + or - operator: : INTERVAL « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. INTERVAL
date + INTERVAL expr unit
date - INTERVAL expr unit


mysql>
mysql> SELECT '1997-12-31 23:59:59' + INTERVAL 1 SECOND;
+-------------------------------------------+
| '1997-12-31 23:59:59' + INTERVAL 1 SECOND |
+-------------------------------------------+
| 1998-01-01 00:00:00                       |
+-------------------------------------------+
1 row in set (0.00 sec)








14.22.INTERVAL
14.22.1.Date arithmetic also can be performed using INTERVAL together with the + or - operator:
14.22.2.SELECT INTERVAL 1 DAY + '1997-12-31';
14.22.3.SELECT '1998-01-01' - INTERVAL 1 SECOND;