[Zope] ZMySQLDA time zone
Richard Wesley
hawkfish@electricfish.com
Mon, 9 Dec 2002 15:10:02 -0800
It appears that the MySQL adapter (2.0.8) assumes that the time zone
of datetime records is the same as the time zone of the machine.
From a quick look at the source, it appears that this is because
DateTime is constructed/parsed without time zone arguments.
This is problematical because we (and I assume many others, as it is
good practice) keep database times in GMT. I can hack up the adapter
to use GMT, but I was wondering if there was a better solution to the
problem (a config setting somewhere).
TIA,
Sincerely,
Richard Wesley
Co-President, Electric Fish, Inc.
<http://www.electricfish.com/>
(v) +1-206-493-1690x210
(f) +1-206-493-1697