Wednesday, 8 February 2017

How to convert unixtime stamp in sql server


--How to convert unixTimestampt in SQL SERVER


DECLARE @UnixTimeStamp BIGINT = 1480272249102285

SELECT DATEADD(S,CONVERT(INT, LEFT(@UnixTimeStamp,10)),'1970-01-01 ')