1//Returns Date time
2//Takes where to add (as in year, month, day, etc) to
3//Takes how much to add
4//Takes a datetime in some different formats
5DATEADD(month, 1, '2017/08/25')
1SELECT GETDATE() 'Today',
2 DATEADD(day,-2,GETDATE()) 'Today - 2 Days'
3SELECT GETDATE() 'Today',
4 DATEADD(dd,-2,GETDATE()) 'Today - 2 Days'
5SELECT GETDATE() 'Today',
6 DATEADD(d,-2,GETDATE()) 'Today - 2 Days'
7