How to convert Seconds to HH:MM:SS using T-SQL

by

You want to multiply out to milliseconds as the fractional part is discarded.

SELECT DATEADD(ms, 121.25 * 1000, 0)

If you want it without the date portion you can use CONVERT, with style 114

SELECT CONVERT(varchar, DATEADD(ms, 121.25 * 1000, 0), 114)

More Related Contents:

  1. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  2. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  3. Convert text to system date format [duplicate]
  4. How to return only the Date from a SQL Server DateTime datatype
  5. Best approach to remove time part of datetime in SQL Server
  6. How to calculate age in T-SQL with years, months, and days
  7. DateTime2 vs DateTime in SQL Server
  8. Levenshtein distance in T-SQL
  9. Sql Server string to date conversion
  10. Convert multiple rows into one with comma as separator [duplicate]
  11. What is the significance of 1/1/1753 in SQL Server?
  12. Select query to remove non-numeric characters
  13. T-SQL: Selecting rows to delete via joins
  14. T-SQL Pivot? Possibility of creating table columns from row values
  15. TSQL divide by zero encountered despite no columns containing 0
  16. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  17. Date conversion and culture: Difference between DATE and DATETIME
  18. t-sql get all dates between 2 dates [duplicate]
  19. Extracting hours from a DateTime (SQL Server 2005)
  20. How to pivot table with T-SQL?
  21. How can I get the sum of multiple datetime values?
  22. Testing for inequality in T-SQL
  23. Can I use the MERGE statement in SQL Server 2005?
  24. Replace a newline in TSQL
  25. Getting Dates between a range of dates
  26. T-SQL – function with default parameters
  27. How to use an Alias in a Calculation for Another Field
  28. Using a cursor with dynamic SQL in a stored procedure
  29. T-SQL Between Dates Confusion
  30. Stored procedure hangs seemingly without explanation

Leave a Comment