AnsweredAssumed Answered

How can I convert starttime bigint into datetime with a SELECT Command?

Question asked by zerenato on Oct 1, 2015
Latest reply on Oct 5, 2015 by Eugene Lee

Hi All,


I try to select Event Frames from SQL Server but can't convert bigint to datetime with default time offset. I try


     SELECT name, DATEADD(SECOND,starttime/1000 + 8*60*60, '19700101')


but it doesn't work.


Can anybody help.




Jose Renato