sql-servert-sqlunix-timestamp
How to convert Unix time in microseconds with SQL Server?
I've seen a lot on converting Unix time from other formats to datetime, but nothing really from microseconds. How can you SELECT a field this with a timestamp of 1470562081943371 without getting overflows with an output of YYYY-MM-DD HH:MM:SS:MM?
Solution
Not sure if this is unit is correct, but...
Declare @UnixTime bigint = 1470562081943371
Select DateAdd(MS,round(((@UnixTime/1000000.)-(@UnixTime/1000000))*1000,0),DateAdd(SECOND,(@UnixTime/1000000),'1970-01-01 00:00:00'))
Returns
2016-08-07 09:28:01.943
Confirmed results with http://www.epochconverter.com/
- SQL Server Cursor performance issue
- Is it possible to determine what caused a duplicate key values
- SQL Server Error "Named Pipes Provider: Could not open a connection to SQL Server [53]"
- SQL Server : login success but "The database [dbName] is not accessible. (ObjectExplorer)"
- R odbc::odbcListDrivers() does not list dirver in /opt/homebrew/etc/odbcinst.ini
- How to perform division in SQL Server?
- How to get date difference from a column?
- How can I determine installed SQL Server instances and their versions?
- How to force SQL Server container to immediately update MDF file in Docker volume?
- Using where clause in Sql Server LEAD
- Combine overlapping date ranges
- Expand the date range between two dates
- Providing string variable into Dynamic SQL SELECT statement WITHOUT it being read as a column name?
- How to store geocoded address information into the database
- Truncate a DDL or DML command
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- Why ISDATE() is returning 9996 as date?
- .NET 8 & SQL Server 2016 - Contains() throws error
- IsDate Function in SQL evaluates invalid dates as valid
- SQL Server - Value passes ISDATE() but fails to CAST as DATE or DATETIME
- Error when connecting to SQL Server in deno: 'cannot find module crypto'
- Multiple many-to-many and multiple one-to-one relationships in the same entities
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Path table to HTML treeview in SQL Server
- SUM and Decimal precision
- Parse TEXT datatype column to grab values based on TAGS
- How can I create a tar file in memory from several varbinary(max) columns stored in SQL Server using .NET native API?
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Maintaining property order with get-member
- migrate data from MS SQL to PostgreSQL?