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