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@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>
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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
----- End forwarded message -----
jesse reed vincent – root@eruditorum.org – jesse@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.