From owner-freebsd-questions@FreeBSD.ORG Wed Nov 9 17:35:56 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6041516A41F for ; Wed, 9 Nov 2005 17:35:56 +0000 (GMT) (envelope-from bsilverstrim@athensasd.org) Received: from mail.athensasd.k12.pa.us (rrcs-24-97-187-226.nys.biz.rr.com [24.97.187.226]) by mx1.FreeBSD.org (Postfix) with ESMTP id DC52243D49 for ; Wed, 9 Nov 2005 17:35:53 +0000 (GMT) (envelope-from bsilverstrim@athensasd.org) Received: from [172.16.0.190] ([172.16.0.190]) by mail.athensasd.k12.pa.us with Microsoft SMTPSVC(5.0.2195.6713); Wed, 9 Nov 2005 12:35:51 -0500 Mime-Version: 1.0 (Apple Message framework v623) Content-Transfer-Encoding: 7bit Message-Id: <06fe145ebc265841b4c499f5dc1e72ab@athensasd.org> Content-Type: text/plain; charset=US-ASCII; format=flowed To: Free BSD Questions list From: Bart Silverstrim Date: Wed, 9 Nov 2005 12:36:43 -0500 X-Mailer: Apple Mail (2.623) X-OriginalArrivalTime: 09 Nov 2005 17:35:51.0644 (UTC) FILETIME=[078A39C0:01C5E554] Subject: log file conversion (OT?) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Nov 2005 17:35:56 -0000 I have Squid running on a FreeBSD system and the log file (access.log) has lines like 1131556815.537 101 172.16.2.153 TCP_HIT/200 35674 GET http://www.urprize2.com/adv77/images/header_08_23_05.gif - NONE/- image/gif 1131556815.584 47 172.16.2.153 TCP_HIT/200 1828 GET http://www.urprize2.com/adv77/images/timer.swf - NONE/- application/x-shockwave-flash in it. Is there a simple way or a one- or two-liner script that can take the epoch time in the first column and replace it with the actual time/date stamp in human-readable format?