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
+-------[ 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 | �
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.
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 akm@theinternet.com.auwrote:
+-------[ 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 | Â
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 akm@theinternet.com.au
+-------[ Justin Dunsworth ]---------------------- | 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?
Not with the same level of flexibility.
The DateTime object contains everything you need to build it up yourself though.
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 ]---------------------- | 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.
He expects (as most of us expect at first) the time not to be converted to the local zone just because you want to format the time display.
-
Andrew Milton -
Justin Dunsworth -
Lennart Regebro