SQL Server: Get data for only the past year

December 18, 2022 by Tarik

The following adds -1 years to the current date:

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