Adddate Sql Code Example

Example: 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'