ADDDATE(date,INTERVAL expr unit)

MySQL 8.4

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

Syntax

MYSQL

SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY);
'2008-02-02'
SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY);
'2008-02-02'

Examples

Example

When invoked with the INTERVAL form of the second argument, ADDDATE() is a synonym for DATE_ADD(). The related function SUBDATE() is a synonym for DATE_SUB(). For information on the INTERVAL unit argument, see Temporal Intervals.

MYSQL

SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY);
'2008-02-02'
SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY);
'2008-02-02'

Example 2

When invoked with the days form of the second argument, MySQL treats it as an integer number of days to be added to expr.

MYSQL

SELECT ADDDATE('2008-01-02', 31);
'2008-02-02'