Answers for "add 1 day to date sql"

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')

datetime add 2 hours sql

DATEADD(HOUR, 2, GETUTCDATE())

sql server today minus n

SELECT GETDATE() - 1