Example
Add one year to a date, then return the date:
SELECT DATEADD(year, 1, '2017/08/25') AS DateAdd;
Definition and Usage
The DATEADD() function adds a time/date interval to a date and then returns the date.
Syntax
DATEADD(interval, number, date)