Reputation: 6918
I want to calculate number of days from a date.
For example, we have @date='03/16/2012'. I want to get number of days up to now.
@date='03/16/2012'
How can I do it?
Upvotes: 3
Views: 20813
Reputation: 138960
datediff(day, @date, getdate())
datediff
Upvotes: 11