[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