MEC LOG SQL SERVER TABLE FIELD LogTime Extraction

unknown

Hello

Greetings!

We are looking for some data from MEC Log Table to analyze the response time for few messages, for which we use below SQL for Date but could you please advise how  extract the timestamp details

We look forward to extract the timestamp details from LogTime field, what is this Format?

SELECT  [Thread], [Category],[LogLevel],[LogTime],[UUID],[Message],
left (DATEADD(S, CONVERT(int,LEFT(LogTime, 10)), '1970-01-01'),11),
FROM [MEC_Storage_PCC].[dbo].[MecLog]

Thanks

unknown

Got the Answer from Google, and it is UnixTimeSTamp Field.

DATEADD(ms, LogTime%(3600*24*1000),dateadd(day, LogTime/(3600*24*1000), '1970-01-01 00:00:00.0'))