Timezone issues (from: laus@suse.cz)

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.


----- Forwarded message from Miroslav Laus laus@suse.cz -----Date: Thu, 26 Jul 2001 11:13:27 +0200
From: Miroslav Laus laus@suse.cz
To: rt-users@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>


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 ?


Miroslav Laus

rt-users mailing list

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

jesse reed vincent – root@eruditorum.orgjesse@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.