FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Debian > Debian ISP

 
 
LinkBack Thread Tools
 
Old 08-12-2008, 10:33 AM
Matthew Macdonald-Wallace
 
Default Apache2 and mod_log_mysql date formats

Hi all,

I've a feeling this may be the wrong place to post, however I know that
Thomas (.deb maintainer for this package) is a lurker on this list, so
apologies in advance where required.

I'm using mod-log-mysql and it's working really well, however the
time_stamp column in the access_log table is an int not a date-time

I'm trying to play with the dates and manipulate them into a particular
format complete with timezones - does anyone know if the dates are
stored in UTC, or are they stored in what ever time-zone the server is
using locally?

Thanks in advance,

Matt
--
Matthew Macdonald-Wallace
matthew@truthisfreedom.org.uk
http://www.truthisfreedom.org.uk


--
To UNSUBSCRIBE, email to debian-isp-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
 
Old 08-12-2008, 11:14 AM
Matthew Macdonald-Wallace
 
Default Apache2 and mod_log_mysql date formats

On Tue, 12 Aug 2008 11:33:19 +0100
Matthew Macdonald-Wallace <lists@truthisfreedom.org.uk> wrote:

> I'm trying to play with the dates and manipulate them into a
> particular format complete with timezones - does anyone know if the
> dates are stored in UTC, or are they stored in what ever time-zone
> the server is using locally?

Never mind, I read the manual again and discovered the request_time
field.

I works fine.

Thanks again,

Matt
--
Matthew Macdonald-Wallace
matthew@truthisfreedom.org.uk
http://www.truthisfreedom.org.uk


--
To UNSUBSCRIBE, email to debian-isp-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
 

Thread Tools




All times are GMT. The time now is 07:59 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org