topic Re: Understanding HP SIM SQL records in Server Management - Systems Insight Manager

Understanding HP SIM SQL records

Mantas Smelevicius_1 — Wed, 22 Jun 2005 05:17:29 GMT

Hello,

I'm writing a little soft, for extracting some events from HP SIM SQL database. And I have problem, for understanding notices timestamp format.
For example in table [notices], value of timestamp is 1119427928093. It's like unix timestamp but.. 13 digits? Normaly unix time lenght is 10 digits. Ok. Let's supose that 3 last digits - it's a milliseconds. So. Question: It is possible to convert this value into human readable format only using SQL functions?

Or any other ideas?

Thanks

Re: Understanding HP SIM SQL records

Mantas Smelevicius_1 — Wed, 22 Jun 2005 05:26:27 GMT

Also on remark

1119427928093 in HP SIM is displaying 2005/06/22 11:12AM ...

Re: Understanding HP SIM SQL records

Mantas Smelevicius_1 — Wed, 22 Jun 2005 05:57:52 GMT

SELECT CONVERT(varchar(10),DATEADD(ss, 1119427928.093, '01-01-1970 03:00'),111)+' '+
CONVERT(varchar(5),DATEADD(ss, 1119427928.093, '01-01-1970 03:00'),108)