MySQL – Add Time Value (Intervals) To Date

MySQL DATE_ADD() function allow you to add a time value (Intervals) to the selected date.

MySQL ADDDATE() function is the synonym of DATE_ADD() function.

The following examples will return a date after adding 31 days with the specified date 2014-01-02.

Syntax – DATE_ADD() Function

DATE_ADD(date,INTERVAL expr unit);

Example:

mysql> SELECT DATE_ADD('2014-01-02', INTERVAL 31 DAY);

Output:

'2014-02-02'

Syntax – ADDDATE() Function

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

Example-1:

mysql> SELECT ADDDATE('2014-01-02', INTERVAL 31 DAY);

Output:

'2014-02-02'

Example-2:

mysql> SELECT ADDDATE('2014-01-02', 31);

Output:

'2014-02-02'

Arguments

The following table shows the expected form of the expr argument for each unit value.