SQL Server : How to get rows where the date is older than X years?

Question

题

我想从数据库中提取所有 Assets ，该数据库已有一定的历史，在这种情况下为年。这个说法正确吗？

背景

该数据库名为 AssetRegister
该表名为 dbo.Assets
该列名为 AcquiredDate
迄今为止的声明

SELECT * FROM dbo.Assets WHERE AcquiredDate < '2008-01-01'

Answer 1

SELECT * FROM dbo.Assets                  
WHERE DATEDIFF(YEAR, AcquiredDate, GetDate()) >= 8

有关性能优化的查询，请查看 @Horaciuxs answer .