dateadd sql code example
Example 1: sql server current date minus 5 years
SELECT GETDATE() 'Today',
DATEADD(day,-2,GETDATE()) 'Today - 2 Days'
SELECT GETDATE() 'Today',
DATEADD(dd,-2,GETDATE()) 'Today - 2 Days'
SELECT GETDATE() 'Today',
DATEADD(d,-2,GETDATE()) 'Today - 2 Days'
Example 2: datetime add 2 hours sql
DATEADD(HOUR, 2, GETUTCDATE())
Example 3: 3 days back in sql server
DATEADD(DAY, -3, GETDATE())
Example 4: sql server today minus n
SELECT GETDATE() - 1