Ram Singh
Ram Singh

Reputation: 6918

Calculating number of days between a date and today in SQL Server?

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.

How can I do it?

Upvotes: 3

Views: 20813

Answers (1)

Mikael Eriksson
Mikael Eriksson

Reputation: 138960

datediff(day, @date, getdate())

datediff

Upvotes: 11

Related Questions