RE: [squid-users] Squid time to people time

Sorry I did not give enough detail. I am trying to analyse the logs in an
MySql database (they are placed there by Squidalyser), however the time is
in Unix format, I wnat to be able to stick a formula in an SQL query to
convert it.

Thanks a lot for the reply

> -----Original Message-----
> From: Colin Campbell [mailto:sgcccdc@citec.qld.gov.au]
> Sent: Thu, 21. November 2002 1:08 PM
> To: squid-users@squid-cache.org
> Subject: Re: [squid-users] Squid time to people time
>
>
> Hi,
>
> This is a FAQ.
>
> On Thu, 21 Nov 2002 12:17:07 +1100
> "Simon Bryan" <sbryan@olmc.nsw.edu.au> wrote:
>
> > Hi all,
> > Whats the formula for converting Squid time in the logs to normal people
> > based time?
>
> On my box I do
>
> perl -pe 's/(\d+\.\d+)/localtime $1/e' /opt/squid/logs/access.log
>
>
> Colin
> --
> Colin Campbell
> Unix Support/Postmaster/Hostmaster
> CITEC
> +61 7 3227 6334
Received on Thu Nov 21 2002 - 10:17:37 MST