ADDDATE

Declaration

ADDDATE(date,INTERVAL expr unit)
ADDDATE(expr,days)

Description

The first declaration of this function is a synonym for DATE_ADD(). For more information about the unit parameter, see DATE_ADD.

The second declaration of this function adds the number of days specified by days to the date specified by expr.

Examples

SELECT ADDDATE('2021-08-01', INTERVAL 31 DAY);
+----------------------------------------+
| ADDDATE('2021-08-01', INTERVAL 31 DAY) |
+----------------------------------------+
| 2021-09-01                             |
+----------------------------------------+
1 row in set (0.001 sec)

SELECT ADDDATE('2021-08-01', 31);
+---------------------------+
| ADDDATE('2021-08-01', 31) |
+---------------------------+
| 2021-09-01                |
+---------------------------+
1 row in set (0.001 sec)