That is the Unix Time
To convert it into normal time use this formula in Excel =(A1+x)/86400+25569
where x is the number of seconds you are from GMT (i.e. if you are in
Sydney, Australia it would be 10*60*60 or 36000) and A1 is the cell in which
the Unix date is present. Also, you will need to format the results cell in
a custom format of DD/MM/YYYY HH:MM:SS otherwise the result will just be a
number.
Hope this helps
Kieran
-----Original Message-----
From: Yuzz [mailto:yuzz@emasonline.com]
Sent: Wednesday, 7 August 2002 13:49
To: Squid Users
Subject: [squid-users] access.log
Hello,
Does anybody know how to read access.log because i don't understand the
number at the beginning of the line
example:
1028417530.382 104 clientIPaddr clientaccesstothisURL
-- Yuzz System Engineer Tel : +606-3345666 Fax : +606-3372233Received on Tue Aug 06 2002 - 22:05:29 MDT
This archive was generated by hypermail pre-2.1.9 : Tue Dec 09 2003 - 17:09:32 MST