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.

 

Thanks,

 

Jose Renato

Outcomes