0 votes
1 view
in SQL by (20.3k points)

I am writing a query in which I have to get the data for only the last year. What is the best way to do this?

SELECT ... FROM ... WHERE date > '8/27/2007 12:00:00 AM'

1 Answer

0 votes
by (36.7k points)

By using the below code, you can add -1 year to the current date:

SELECT ... From ... WHERE date > DATEADD(year,-1,GETDATE())

...