Repository error log timestamp

[jherron]

does anyone know how to read the audittimestamp in the WMERROR table in the IS repository ? I've tried searching for this information for about a week and haven't been able to find it.

For instance, the audit timestamp reads: 1066399911316, which should represent 2003-10-17 10:11:51.

Are there any services that do this conversion- Obviously there is some answer since the admin page reads from the database and it shows up correctly.

Thanks,
Jessica

[castropb]

Give this a try and see if it works for you. You may have to tweak the 14400000 to match your time zone. This value is in milliseconds. I have to subtract 4 hours from the timestamp to get the correct result for my time zone.

SELECT ROOTCONTEXTID,
PARENTCONTEXTID,
CONTEXTID,
AUDITTIMESTAMP,
(to_date('01-jan-1970','dd-mon-yyyy') + (AUDITTIMESTAMP - 14400000) / 86400000) AS ERROR_DT,
SERVERID,
ERRORMSG,
ERRSTACKTRACE,
SERVICENAME
FROM WMERROR
ORDER BY AUDITTIMESTAMP DESC

[jherron]

Thank you Richard and Percio.

I have tried the second suggestion and it worked very well- sometimes the seconds are off by 1 or so, but its close enough. I will be trying the first option today!

Thanks again!
Jessica