SQL SERVER: Get total days between two dates

by

PRINT DATEDIFF(DAY, '1/1/2011', '3/1/2011') will give you what you’re after.

This gives the number of times the midnight boundary is crossed between the two dates. You may decide to need to add one to this if you’re including both dates in the count – or subtract one if you don’t want to include either date.

More Related Contents:

  1. SQL “between” not inclusive
  2. Efficiently convert rows to columns in sql server
  3. T-SQL split string
  4. How can I get column names from a table in SQL Server?
  5. Conditional WHERE clause in SQL Server
  6. How can I select the first day of a month in SQL?
  7. GROUP BY to combine/concat a column [duplicate]
  8. Select statement to find duplicates on certain fields
  9. Copy data into another table
  10. Using a Variable in OPENROWSET Query
  11. How to find current transaction level?
  12. Find closest date in SQL Server
  13. How do I see active SQL Server connections?
  14. EXISTS vs JOIN and use of EXISTS clause
  15. Check for file exists or not in sql server?
  16. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  17. Group DateTime into 5,15,30 and 60 minute intervals
  18. Why is a UDF so much slower than a subquery?
  19. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  20. Alternate of lead lag function in SQL Server 2008
  21. UNIX_TIMESTAMP in SQL Server
  22. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  23. How can I group by date time column without taking time into consideration
  24. The transaction log for the database is full
  25. Generate random int value from 3 to 6
  26. Add emoji / emoticon to SQL Server table
  27. Select SQL Server database size
  28. Backup a single table with its data from a database in sql server 2008
  29. COALESCE Function in TSQL
  30. Try_Convert for SQL Server 2008 R2

Leave a Comment