ADDDATE(date,INTERVAL expr unit), : ADDDATE « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. ADDDATE

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

mysql>
mysql> SELECT ADDDATE('1998-01-02', INTERVAL 31 DAY);
+----------------------------------------+
| ADDDATE('1998-01-02', INTERVAL 31 DAY) |
+----------------------------------------+
| 1998-02-02                             |
+----------------------------------------+
1 row in set (0.00 sec)

mysql>