[rt-devel] [fwd] [rt-users] Timezone issues (from: laus@suse.cz)

[Jesse]

So, having prodded at this a bit,  I'm sort of at a loss.  At least
postgres and oracle's date weirdness is controllable on a per-session basis.
I can deal with timezones within the context of an sql session.
Mysql seems to treat the server's timezone as a server-level config option
that is neither exposed or mutable within a session. Has anyone ever dealt
with this before? 

I'm starting to feel like I would have been better off
using seconds-since-the-epoch for all of RT's date storage. 
        
        -J

----- Forwarded message from Miroslav Laus <laus at suse.cz> -----

Date: Thu, 26 Jul 2001 11:13:27 +0200
From: Miroslav Laus <laus at suse.cz>
To: rt-users at lists.fsck.com
User-Agent: Mutt/1.2.5i
Subject: [rt-users] Timezone issues
List-Id: For users of RT: Request Tracker <rt-users.lists.fsck.com>

Hi,

I'm fighting this timezone issue:

My box is set to Europe/Prague (so CET comes in use), my MySQL server
is being started with --timezone=CET and config.pm reads $Timezone='CET'.
But after sending a mail to RT, RT says it was received 6 hours ago.
Any comments on this ?

Greets,

Miroslav Laus


_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


----- End forwarded message -----

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

<Dr_Memory> the point is that words were exchanged.  neurolinguistic
programming will do the rest.  they should be showing up at my house
any day now.