[Zope] Time zones (another try)

[Richard Wesley]

Ken -

At 3:16 PM -0500 12/12/02, ken wrote:
>Richard,
>
>I'm not following the rationale for wanting your database to think it's
>GMT, but that's okay.

We have to pick a representation for the database because it does not 
appear to support one natively.  The choices are either UTC or or 
local time.  If we decide to share a database among several servers 
distributed around the world, they all need to agree on a single time 
representation, at which point "local time" becomes meaningless. 
Hence our use of UTC.

>Whatever time you want MySQL to think it is can
>be set at the command line with the --timezone option, like
>
>--timezone=UTC
>
>If you're curious, this is processed by /usr/bin/safe_mysqld.

Fabulous.  Thanks for the info.

>Also
>check to see if there's something in /etc/my.conf like
>
>TZ=PST8PDT
>export TZ
>
>Again, change the value to your desired timezone.

I will check these out.

There is still the problem, though, of how to make Zope send GMT 
through the ZMySQLDA module.  I can hack up the adapter, but I was 
sort of hoping that there was some sort of configuration for it.
Sincerely,

Richard Wesley
Co-President, Electric Fish, Inc.
<http://www.electricfish.com/>
(v) +1-206-493-1690x210
(f) +1-206-493-1697