Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT INTERVAL 1 DAY + 1997-12-31

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>