[mrtg] Re: Log Files and Date

Tue Dec 14 17:00:39 MET 1999

We're running MRTG on a Red Hat Linux 6.0, and the base for the timestamp on
our system is 12/31/69 7PM.  Which makes the conversion formula (using "1904
base" in Excel)

=(x+((365*66+(19-5/24)*86400))/86400

If you want to make sure that the formula is calculating correctly, test it
using "x=0" and see if you get the timestamp base that you expect.  Or run
the mrtg script and grab the most recent timestamp from your log file, plug
it in, and see if it gives you the correct time.

Greg S.

-----Original Message-----
From: Palmer, Doug [mailto:dougp at ssd.fsi.com]
Sent: Monday, December 13, 1999 2:00 PM
To: mrtg at list.ee.ethz.ch
Subject: [mrtg] Re: Log Files and Date

Excerpt from mrtg-2.8.8/doc/logfile-format.txt

The Unix timestamp (1.A) when the data on
this line was gathered.

This timestamp may be converted in EXCEL by
using the following formula and choosing the
option for the "1904 base":

 =(x+((365*66+17)*86400))/86400

If the "1900 base" is selected, then change
the "66" value to "70".

Douglas Palmer
Associate Network Engineer
FlightSafety International
2700 N. Hemlock Circle
Broken Arrow, Ok. 74012
(918)-259-5523
mailto:dougp at ssd.fsi.com

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:mrtg-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/mrtg

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:mrtg-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/mrtg