MS SQL Server - Convert millisecond timestamp to date history

5 years ago

Full Code

DECLARE @UTC BIGINT
SET @UTC = 1348203320997 

-- This is a comment

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



5 years ago

Full Code

DECLARE @UTC BIGINT
SET @UTC = 1348203320997 

-- This is a comment

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



5 years ago

Full Code

DECLARE @UTC BIGINT
SET @UTC = 1348203320997 

-- This is a comment

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



5 years ago

Full Code

DECLARE @UTC BIGINT
SET @UTC = 1348203320997 


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



5 years ago

Full Code

DECLARE @UTC BIGINT
SET @UTC = 1348203320997 


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