Last Updated : 23 Jul, 2025
DATE_ADD() function in MySQL is used to add a specified time or date interval to a specified date and then return the date.
Syntax:
DATE_ADD(date, INTERVAL value addunit)
Parameter: This function accepts two parameters which are illustrated below:
Returns :
It returns the new date after the addition of a specified time or date.
Example 1:
Getting a new date of “2020-11-22” after the addition of 3 years to the specified date “2017-11-22”.
SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);
Output:
2020-11-22
Example 2:
Getting a new date of “2020-11-22” after the addition of 2 months to the specified date “2020-9-22”.
SELECT DATE_ADD("2020-9-22", INTERVAL 2 MONTH);
Output:
2020-11-22
Example 3:
Getting a new date of “2020-11-22” after the addition of 10 days to the specified date “2020-11-12”.
SELECT DATE_ADD("2020-11-12", INTERVAL 10 DAY);
Output:
2020-11-22
Example 4:
Getting a new date of “2020-11-22 09:12:10” after the addition of 3 hours to the specified date “2020-11-22 06:12:10”.
SELECT DATE_ADD("2020-11-22 06:12:10", INTERVAL 3 HOUR);
Output:
2020-11-22 09:12:10
Example 5:
Getting a new date of “2020-11-22 09:09:10” after the addition of 3 minutes to the specified date “2020-11-22 09:06:10”.
SELECT DATE_ADD("2020-11-22 09:06:10", INTERVAL 3 MINUTE);
Output:
2020-11-22 09:09:10
Example 6:
Getting a new date of “2020-11-22 09:09:10” after the addition of 5 seconds to the specified date “2020-11-22 09:09:5”.
SELECT DATE_ADD("2020-11-22 09:09:5", INTERVAL 5 SECOND);
Output:
2020-11-22 09:09:10
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4