Hi,

got a problem converting a date logged by Cisco in integer format to a proper date format.

The cisco date is logged as 1088706777 which should equate to 01 Jul 2004 13:32:57, and does this in the cisco system.


Now as I understand it this number should be the number of secons sins the 1/1/1970 and the following query will give you the date

DECLARE @mydate_sm DATETIME
SET @mydate_sm = '1/1/70 00:00:00'
select @mydate_sm + (((1088706777)/60/60)/24)

This resolves into the following date:

2004-07-01 00:00:00.000

which is correct however the time are not there and only the date

Any ideas?

Thanks,

Jacques