Calculating timespan with t-sql

by

You can get the difference between the two dates to whatever resolution you want (in your example, minutes):

DATEDIFF(minute, @start_date, @end_date)

From there it’s a simple matter of dividing minutes into hours and hours into days and modding the remainder.

More Related Contents:

  1. Retrieving last record in each group from database – SQL Server 2005/2008
  2. Base64 encoding in SQL Server 2005 T-SQL
  3. How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
  4. Isoweek in SQL Server 2005
  5. Aggregate SQL Function to grab only the first from each group
  6. Insert results of a stored procedure into a temporary table
  7. Check if table exists in SQL Server
  8. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  9. How important is the order of columns in indexes?
  10. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  11. Convert Xml to Table SQL Server
  12. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  13. Is it possible to select sql server data using column ordinal position
  14. How to use alias column name in where clause in SQL Server
  15. How do I group on continuous ranges
  16. Dynamic SQL to generate column names?
  17. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  18. Aggregate bitwise-OR in a subquery
  19. How to split string using delimiter char using T-SQL?
  20. How to find consecutive rows based on the value of a column?
  21. Can I use the MERGE statement in SQL Server 2005?
  22. SQL server select distinct rows using most recent value only
  23. What good are SQL Server schemas?
  24. Problem with Renaming a Column in SQL Server
  25. How to escape square brackets inside square brackets for field name
  26. Average of multiple columns
  27. SQL Server: How to permission schemas?
  28. Eliminate and reduce overlapping date ranges
  29. SQL Server: How to tell if a database is a system database?
  30. Memory effective way to read BLOB data in C#/SQL 2005

Leave a Comment