How to calculate difference in hours (decimal) between two dates in SQL Server?

by

DATEDIFF(hour, start_date, end_date) will give you the number of hour boundaries crossed between start_date and end_date.

If you need the number of fractional hours, you can use DATEDIFF at a higher resolution and divide the result:

DATEDIFF(second, start_date, end_date) / 3600.0

The documentation for DATEDIFF is available on MSDN:

http://msdn.microsoft.com/en-us/library/ms189794%28SQL.105%29.aspx

More Related Contents:

  1. Sql Server string to date conversion
  2. What is the significance of 1/1/1753 in SQL Server?
  3. How to get Time from DateTime format in SQL?
  4. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  5. Date conversion and culture: Difference between DATE and DATETIME
  6. How can I get the sum of multiple datetime values?
  7. SQL Server – error when creating stored procedure
  8. How can foreign key constraints be temporarily disabled using T-SQL?
  9. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  10. How can I select the first day of a month in SQL?
  11. Maximum size of a varchar(max) variable
  12. best way to convert and validate a date string
  13. How do I format a number with commas in T-SQL?
  14. Is there a way to simplify a NULL compare of 2 values
  15. TSQL Try / Catch within Transaction or vice versa?
  16. What is the maximum number of characters that nvarchar(MAX) will hold?
  17. TSQL: Create a view that accesses multiple databases
  18. Sequence as default value for a column
  19. Aggregate bitwise-OR in a subquery
  20. How do I flush the PRINT buffer in TSQL?
  21. OR Operator Short-circuit in SQL Server
  22. How to change default language for SQL Server?
  23. T-SQL incrementing counter based on change in a column value
  24. T-SQL XOR Operator
  25. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  26. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  27. “If not exists” fails on SQL CE
  28. Does the `nodes()` method keep the document order?
  29. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  30. Generate MD5 hash string with T-SQL

Leave a Comment