Convert unix epoch timestamp to TSQL datetime

by

Easy, first add whole days, then add the remaining ms. There are 86,400,000 milliseconds in a day.

declare @unixTS bigint
set @unixTS = 1359016610667


select dateadd(ms, @unixTS%(3600*24*1000), 
    dateadd(day, @unixTS/(3600*24*1000), '1970-01-01 00:00:00.0')
)

The result is 2013-01-24 08:36:50.667

More Related Contents:

  1. How to calculate age in T-SQL with years, months, and days
  2. Levenshtein distance in T-SQL
  3. Convert multiple rows into one with comma as separator [duplicate]
  4. How to get sp_executesql result into a variable?
  5. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  6. How can I use optional parameters in a T-SQL stored procedure?
  7. Select query to remove non-numeric characters
  8. T-SQL Decimal Division Accuracy
  9. Selecting a Record With MAX Value
  10. How to convert Seconds to HH:MM:SS using T-SQL
  11. T-SQL: Selecting rows to delete via joins
  12. Combining INSERT INTO and WITH/CTE
  13. T-SQL Pivot? Possibility of creating table columns from row values
  14. Getting the minimum of two values in SQL
  15. TSQL divide by zero encountered despite no columns containing 0
  16. T-SQL CASE Clause: How to specify WHEN NULL
  17. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  18. t-sql get all dates between 2 dates [duplicate]
  19. Convert Unix time with PowerShell
  20. How to pivot table with T-SQL?
  21. Testing for inequality in T-SQL
  22. Can I use the MERGE statement in SQL Server 2005?
  23. Replace a newline in TSQL
  24. T-SQL – function with default parameters
  25. How to use an Alias in a Calculation for Another Field
  26. Using a cursor with dynamic SQL in a stored procedure
  27. T-SQL Between Dates Confusion
  28. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  29. How to parse string into date?
  30. Stored procedure hangs seemingly without explanation

Leave a Comment