The SQL DATE_ADD is a mySql function which is same as SQL ADDDATE(), it’s used to add time values (intervals) to a date value.

Note: In SQL Server, we could use SQL DATEADD() function.

SQL DATE_ADD Syntax

DATE_ADD(date-expression, INTERVAL expr type)

For the type, please refer to the SQL ADDDATE() function.

SQL DATE_ADD Examples

SELECT DATE_ADD('2010-08-12', INTERVAL 3 DAY) AS NewDate

Result: 2010-08-15

SELECT DATE_ADD('2010-08-12', INTERVAL '3-2' YEAR_MONTH) AS NewDate

Result: 2013-10-12

SELECT DATE_ADD('2011-09-14 2:44:36', INTERVAL '2:26' HOUR_MINUTE) AS NewDate

Result: 2011-09-14 05:10:36