SQL time difference between two dates result in hh:mm:ss

by 
declare @StartDate datetime, @EndDate datetime

select @StartDate="10/01/2012 08:40:18.000",@EndDate="10/04/2012 09:52:48.000"

select convert(varchar(5),DateDiff(s, @startDate, @EndDate)/3600)+':'+convert(varchar(5),DateDiff(s, @startDate, @EndDate)%3600/60)+':'+convert(varchar(5),(DateDiff(s, @startDate, @EndDate)%60)) as [hh:mm:ss]

This query will helpful to you.

More Related Contents:

  1. How can I remove duplicate rows?
  2. SQL Server: Examples of PIVOTing String data
  3. How do I create a unique constraint that also allows nulls?
  4. Using T-SQL, return nth delimited element from a string
  5. How do I get list of all tables in a database using TSQL?
  6. Get first day of week in SQL Server
  7. What is the significance of 1/1/1753 in SQL Server?
  8. SELECT DISTINCT on one column
  9. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  10. Escape a string in SQL Server so that it is safe to use in LIKE expression
  11. Insert Update trigger how to determine if insert or update
  12. Confused about UPDLOCK, HOLDLOCK
  13. Is there a way to simplify a NULL compare of 2 values
  14. TSQL Try / Catch within Transaction or vice versa?
  15. What is the maximum number of characters that nvarchar(MAX) will hold?
  16. TSQL Email Validation (without regex)
  17. Dynamic SQL results into temp table in SQL Stored procedure
  18. SQL Server Output Clause into a scalar variable
  19. How do I flush the PRINT buffer in TSQL?
  20. TABLOCK vs TABLOCKX
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. How do I select last 5 rows in a table without sorting?
  23. SELECT INTO a table variable in T-SQL
  24. T-SQL query to show table definition?
  25. How can I insert binary file data into a binary SQL field using a simple insert statement?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Include missing months in Group By query
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Update SQL with consecutive numbering
  30. Count number of records returned by group by

Leave a Comment