Format of Squid log time stamp

[ITWombat]

In March uk101man posted a nice script to read the URL history files kept by Internet Explorer in a user's profile. I wanted to write a script to process Squid access log for our on-site proxy but I can't workout the the format of the time stamp it uses.

Does anyone how to convert it into a human readble format.
I haven't got the time to go all Blechly Park on its ass.

[plexer]

isn't it the amount of seconds elapsed since a specific time? 1970?

The format is "Unix time" (seconds since Jan 1, 1970) with millisecond resolution.

Ben

[ITWombat]

Thanks for that Ben.

You're not the same Ben of the Unix Time Stamp .com fame are you?

[ITWombat]

Doh!

Just found this on the Squid mailing list

perl -p -e 's/^([0-9]*)/"[".localtime($1)."]"/e' <access.log

[Geoff]

You might want to hook something up more permenant. There's serveral log parsers that will produce pretty reports from squid logs as web pages.

[plexer]

@IT : nope nothing to do with that.

Cheers.

[mark]

@IT Feel the urge to share?