Understanding HP SIM SQL records

[Mantas Smelevicius_1]

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

[Mantas Smelevicius_1]

Also on remark

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

[Mantas Smelevicius_1]

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)