On Wed, Dec 23, 2009 at 18:24, Justin Dunsworth <justin.dunsworth@gmail.com> wrote:
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.
What would you expect it to be? It seems correct to me. -- Lennart Regebro: Python, Zope, Plone, Grok http://regebro.wordpress.com/ +33 661 58 14 64