Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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)