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

MySQL TUTORIALS » Date Time Functions » ADDDATE »

ADDDATE(date,INTERVAL expr unit),


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>