Convert UTC Milliseconds to DATETIME in SQL server

by 
DECLARE @UTC BIGINT
SET @UTC = 1348203320997 

SELECT DATEADD(MILLISECOND, @UTC % 1000, DATEADD(SECOND, @UTC / 1000, '19700101'))

More Related Contents:

  1. Sql Server string to date conversion
  2. How to get Time from DateTime format in SQL?
  3. SQL Query to find the last day of the month
  4. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  5. SQL query to select dates between two dates
  6. Natural (human alpha-numeric) sort in Microsoft SQL 2005
  7. How much size “Null” value takes in SQL Server
  8. SQL Server Pivot Table with multiple column aggregates
  9. How to get first and last day of previous month (with timestamp) in SQL Server
  10. Why is it considered bad practice to use cursors in SQL Server?
  11. How to remove the time portion of a datetime value (SQL Server)?
  12. CAST and IsNumeric
  13. Is it possible to force row level locking in SQL Server?
  14. SQL Server – Dynamic PIVOT Table – SQL Injection
  15. SQL Server, convert a named instance to default instance?
  16. SQL Server GUID sort algorithm. Why?
  17. WHERE clause on SQL Server “Text” data type
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Unable to begin a distributed transaction
  20. Comparing dates stored as varchar
  21. Add default value of datetime field in SQL Server to a timestamp
  22. SQL server schema and default schema
  23. SQL Server ON DELETE Trigger
  24. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  25. FOR XML PATH(”): Escaping “special” characters
  26. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  27. Difference between database and schema
  28. What are row, page and table locks? And when they are acquired?
  29. Cross Domain SQL Server Logins Using Windows Authentication
  30. How does SQL Server decide format for implicit datetime conversion?

Leave a Comment