Endpoint Protection

Good afternoon. I am developing some reports that read information from the sem5 database in SQL. Specifically, from the dbo.AGENT_BEHAVIOR_LOG_1 and 2 tables. The date and time columns use what appears to be an offset value: i.e. Time_Stamp is 1433255648842. Does anyone know the formula or the calculation needed to convert these columns to the actual date and time?

Thank you.

Epoch time I believe..try this:

select dateadd( SECOND, 1354320000, '1970-1-1' )

That did the trick. The number is large enough that I have to divide by 1000 to get the actual hours and minutes; otherwise, it's too large to be stored in the column. And I'm guessing it is expressed in UTC time, so I will need to add an offset for my time zone. If I am incorrect on that, let me know.

Thank you very much!

Great! please don't forget to close out thread as solved..have a good one!