BACK

0
Posted by albydarned 5 years ago
MS SQL Server - Convert millisecond timestamp to date
Useful snippet for converting millisecond timestamp to date in MS SQL Server

DECLARE @UTC BIGINT
SET @UTC = 1348203320997 

-- This is a comment

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