[Zope] Time zones (another try)

Russell Hires rhires@earthlink.net
Thu, 12 Dec 2002 12:24:29 -0500


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Agreed, and we are doing the basics (rdate daemon).  But the central
> issue remains:  How do I convince MySQL to store dates as GMT, not
> local time?  Judging from the Now() test I just did, the only
> solution is to change the system time to GMT.
So you're using Linux. Couldn't you write a trigger that gets the hwclock() 
time? 

Why are you having MySQL keep up with the time? Why not just deal with 
ZopeTime, then subtract the appropriate amount of time based on whether it's 
DST or not? After all, how does your computer know when to change its clock 
(to DST or back)?  Is that an overhead problem that you're trying to avoid? 
Sorry these are simple solutions, but maybe that's what's needed?

Russell
- -- 
Linux -- the OS for the Renaissance Man 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9+MZNAqKGrvVshJQRAmNLAKCEYM6KBjQMeWE8NDeuNgdx+TIM9ACffETj
VFU/Jer6rmIqozi1vPUg9kg=
=Zvt5
-----END PGP SIGNATURE-----