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

sql sql-server datetime count days
Ram Singh picture Ram Singh · Jul 8, 2012 · Viewed 17.1k times · Source

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?

Answer

Mikael Eriksson picture Mikael Eriksson · Jul 8, 2012 
datediff(day, @date, getdate())

datediff

Related questions

How to return only the Date from a SQL Server DateTime datatype

SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00:00:00.000 How can I get that?

Read More
SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me pointing the mistake in my query. select Date,TotalAllowance from Calculation where EmployeeId=1 and Date …

Read More
How to convert DateTime to VarChar

I am working on a query in Sql Server 2005 where I need to convert a value in DateTime variable into a varchar variable in yyyy-mm-dd format (without time part). How do I do that?

Read More