sql server add days to current date code example

Example 1: sql add days to date

//Returns Date time
//Takes where to add (as in year, month, day, etc) to
//Takes how much to add
//Takes a datetime in some different formats
DATEADD(day, 1, '2017/08/25')

Example 2: datetime add 2 hours sql

DATEADD(HOUR, 2, GETUTCDATE())

Example 3: sql server today minus n

SELECT GETDATE() - 1