Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

Adding one month to a date

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