Hi,
the formula we use to convert the netview 5.0 for NT date format to the
windows date format is:
([SnmpcollectData]![endTime]+2209161600)/(24*60*60)+0.5
Note:
2209161600 = number of second between the windows 'zero' date (1/1/1900
12 AM) and the netview 'zero' date (1/1/1970 12 AM) -- (d/m/yy)
(24*60*60) = number of seconds in a day
0.5 = 12 hours (in windows date format) because NZ is 12 hrs ahead of
GMT
Regards,
Matt Moore
>-----Original Message-----
>From: Ken Ho [SMTP:KenH@dex.co.za]
>Sent: Wednesday, September 16, 1998 10:05 PM
>To: Matt Moore
>Subject: FW: Corruption of default & map formula for date and time (??
>time
>zone based??)
>
>could you please help in regards to the formula, that you had sent to
>dsparg.
>
>is it time zone based
>
>-----Original Message-----
>From: Debbie Sparg [mailto:dsparg@fgh.co.za]
>Sent: Wednesday, September 16, 1998 11:22
>To: 'Ken Ho'
>Subject: RE: Corruption of default map
>
>
>
>Hi Ken,
>
>Sorry, I don't believe it is possible to restore the default map from
>the other copies. Unless you have a backup of the default to restore
>from I think the only other option is to clear the databases and start
>discovery from the beginning.
>NetView 5.1 is available now and you should be receiving that soon,
>maybe it will resolve this problem of the map getting corrupted. Backups
>are important however,you should get them in place as soon as possible.
>
>The person who sent me the formula for the date and time is Neal
>Wallace. He works for a Business Partner in New Zealand. His email
>address is: NealW@datacom.co.nz
>He told me he would be moving out of the NetView arena but I'm sure he
>will still help you if he can. I also think that the problem of the date
>being a day out is something to do with time zones as New Zealand would
>be approximately 13 hours ahead of us.
>The value of the date field is the number of seconds from the 01/01/1970
>up to the current time when the record was written.
>
>Regards
>Debbie
>
>>-----Original Message-----
>>From: Ken Ho [SMTP:KenH@dex.co.za]
>>Sent: Wednesday, September 16, 1998 10:48 AM
>>To: Debbie Sparg
>>Cc: Juri Busek
>>Subject: Corruption of default map
>>
>>Debbie.
>>
>>
>>Tivolli has once again corrupted the default map.
>>
>>
>>Is there a way that the map can be restored from the other copies of
>the
>>maps?
>>
>>Also
>>
>>With regards to the date and time formula. Is it possible for you to
>>email the person from which you got the formula
>>as to the details about the formula, specifically in regards with
>>whether they are using it in a time zone scenario, which could explain
>>the incorrect date and possibly the time shown.
|