Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

Adding one year to a date

mysql> mysql> SELECT DATE_ADD('2006-05-01',INTERVAL 1 YEAR); +----------------------------------------+ | DATE_ADD('2006-05-01',INTERVAL 1 YEAR) | +----------------------------------------+ | 2007-05-01                             | +----------------------------------------+ 1 row in set (0.02 sec)