Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

Adding one day to a date

mysql> mysql> SELECT DATE_ADD('2006-05-01',INTERVAL 1 DAY); +---------------------------------------+ | DATE_ADD('2006-05-01',INTERVAL 1 DAY) | +---------------------------------------+ | 2006-05-02                            | +---------------------------------------+ 1 row in set (0.00 sec) mysql>