Re: [Zope] DateTime Issues
+---[ Lennart Regebro ]-- | On Wed, Dec 23, 2009 at 18:24, Justin Dunsworth | 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 | > 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 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 a...@theinternet.com.au ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] DateTime Issues
On Wed, Dec 23, 2009 at 18:24, Justin Dunsworth 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 > 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 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 ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] DateTime Issues
+---[ 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. -- Andrew Milton a...@theinternet.com.au ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] DateTime Issues
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 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 > | 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 > | 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 > a...@theinternet.com.au > ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )
Re: [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 | 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 | 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 a...@theinternet.com.au ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )