MySQL Tutorial/Date Time Functions/INTERVAL
Date arithmetic also can be performed using INTERVAL together with the + or - operator:
<source lang="sql">
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)</source>
SELECT "1998-01-01" - INTERVAL 1 SECOND;
<source lang="sql">
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></source>
SELECT INTERVAL 1 DAY + "1997-12-31";
<source lang="sql">
mysql> mysql> SELECT INTERVAL 1 DAY + "1997-12-31"; +-------------------------------+ | INTERVAL 1 DAY + "1997-12-31" | +-------------------------------+ | 1998-01-01 | +-------------------------------+ 1 row in set (0.00 sec) mysql></source>