[Zope] DateTime Issues

[Justin Dunsworth]

I am having difficulties with time zones and rendering proper times/dates.
My time zone is GMT-6 (CST)... mysql reports the proper time/date, running
<dtml-var expr="e.strftime('%c')"> shows Zope has the right date, running a
query straight from the SQLMethod shows the proper time in relation to the
field in mysql. However, when I try and run the variable in the dtml
document it gives the time in GMT+0.

For example... in mysql I have "2009-12-23 10:41:06" as the date of
the record. Running the SQL Method returns it as '2009/12/23 10:41:06 GMT+0'
-- So far so good but when I run <dtml-var comment_date fmt="%m-%d-%y
%H:%M"> in my document it gives: 12-23-09 04:41.

I can get fmt=ISO (and other similar time functions) working and showing the
proper date/time but I'd rather have a little more control over how the time
is displayed. Is there any suggestions on what to do? I've looked many
places and couldn't find the answer.

I am running Zope 2.11.4-final, python 2.4.4, win32

Regards,
-J
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20091223/06a1a074/attachment.html