Date Time Functions MySQL Tutorial

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