How to find 2 years back date

Question

I want to find today's date but it should be 2 years back. E.g today's date is 6/12/2010 but I want 6/12/2008. How can I do this in SQL server?

Answer 1

SELECT DATEADD(year, -2, GETDATE())

or

SELECT DATEADD(yy, -2, GETDATE())

or

SELECT DATEADD(yyyy, -2, GETDATE())

If you want to store it as a variable:

DECLARE @twoYearsAgo DATETIME;  SELECT @twoYearsAgo = DATEADD(year, -2, GETDATE());