Apache2 and mod_log_mysql date formats - Debian

This is a discussion on Apache2 and mod_log_mysql date formats - Debian ; 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 ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Apache2 and mod_log_mysql date formats

  1. 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

  2. Re: Apache2 and mod_log_mysql date formats

    On Tue, 12 Aug 2008 11:33:19 +0100
    Matthew Macdonald-Wallace 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

+ Reply to Thread