Ah-ha... that would make sense. Is there a way to display it without
stripping the timezone information or at least add another time preset?
On Wed, Dec 23, 2009 at 11:30 AM, Andrew Milton <a...@theinternet.com.au>wrote:
> +-------[ 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
> | query straight from the SQLMethod shows the proper time in relation to
> | field in mysql. However, when I try and run the variable in the dtml
> | 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
> | -- So far so good but when I run <dtml-var comment_date fmt="%m-%d-%y
> | in my document it gives: 12-23-09 04:41.
> | Â
> | I can get fmt=ISO (and other similar time functions) working and showing
> | 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
> | Â
> using fmt / strftime on Zope DateTime strips the timezone info and
> converts to localzone before rendering, which is why your times are out
> by 6 hours... your distance from GMT.
> Andrew Milton
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -