Subtract two dates in SQL and get days of the result - Stack Overflow

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

stackoverflow.com