How do I translate the TIME_STAMP data in the Symantec Endpoint Protection Manager (SEPM) database into a human readable date format?
The TIME_STAMP column in many tables inside the SEPM database is stored as Epoch time, in milliseconds since the 1st of January 1970. To convert this number into a readable date format you can use the following SQL statement:
select TIME_STAMP, convert(char(19),dateadd(ss,(TIME_STAMP/1000),convert(datetime,'1970/01/01',111)),20) as readable_time from table_name
Imported Document ID: TECH168912
Subscribing will provide email updates when this Article is updated. Login is required.