sql server - Subtract two dates in SQL and get days of the result

Question

Select I.Fee
From Item I
WHERE GETDATE() - I.DateCreated < 365 days

How can I subtract two days? Result should be days. Ex: 365 days. 500 days.. etc...

question from:https://stackoverflow.com/questions/14119277/subtract-two-dates-in-sql-and-get-days-of-the-result

Answer 1

Use DATEDIFF

Select I.Fee
From Item I
WHERE  DATEDIFF(day, GETDATE(), I.DateCreated) < 365