I was a bit suprised to see that the "UTC" timezone is actually
hardcoded into the default date/time formats in OPS, and is displayed against any dateTime/time regardless of the actual timezone! eg 13:20:00.000-05:00 is displayed as 13:20:00 UTC Which is incorrect. I think these expressions in org.orbeon.oxf.xforms.XFormsControls need fixing (and the defaults in properties.xml) - the latter two should use [Z] instead of the UTC literal, and the former should include [Z] also since a date can have a timezone component (which can't be input, but often dates generated by external sources are displayed as outputs on a form). "if (. castable as xs:date) then format-date(xs:date(.), '[MNn] [D], [Y]', 'en', (), ()) else ." "if (. castable as xs:dateTime) then format-dateTime(xs:dateTime(.), '[MNn] [D], [Y] [H01]:[m01]:[s01] UTC', 'en', (), ()) else ." "if (. castable as xs:time) then format-time(xs:time(.), '[H01]:[m01]:[s01] UTC', 'en', (), ()) else ." The ouput isn't perfect in the current OPS version of saxon : it will output 'Z' (which is equal to UTC) when there is no timezone, whereas it should output nothing (a date/time/dateTime without a timezone cannot be assumed to be UTC: it's timezone must be considered unknown). But this is fixed in 8.6 (see the last point in http://www.saxonica.com/documentation/changes/intro86/xslt86.html), along with support for [ZN] which outputs the timezone name instead of the numerical offset - eg EST instead of -05:00. Although for this to work correctly country should be specified also. Any idea when Saxon will be upgraded? Adrian -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
Administrator
|
Adrian,
For the formatting issue I have added a bug to tracker and will let Erik have a look at this code. http://forge.objectweb.org/tracker/index.php?func=detail&aid=304746&group_id=168&atid=350207 For the Saxon upgrade, stay tuned! I can't say more at this point ;). Alex On 3/5/06, Adrian Baker <[hidden email]> wrote: > I was a bit suprised to see that the "UTC" timezone is actually > hardcoded into the default date/time formats in OPS, and is displayed > against any dateTime/time regardless of the actual timezone! > > eg > > 13:20:00.000-05:00 > is displayed as > 13:20:00 UTC > > Which is incorrect. > > I think these expressions in org.orbeon.oxf.xforms.XFormsControls need > fixing (and the defaults in properties.xml) - the latter two should use > [Z] instead of the UTC literal, and the former should include [Z] also > since a date can have a timezone component (which can't be input, but > often dates generated by external sources are displayed as outputs on a > form). > > "if (. castable as xs:date) then > format-date(xs:date(.), '[MNn] [D], [Y]', 'en', (), ()) else ." > > "if (. castable as xs:dateTime) then > format-dateTime(xs:dateTime(.), '[MNn] [D], [Y] [H01]:[m01]:[s01] > UTC', 'en', (), ()) else ." > > "if (. castable as xs:time) then > format-time(xs:time(.), '[H01]:[m01]:[s01] UTC', 'en', (), ()) else ." > > The ouput isn't perfect in the current OPS version of saxon : it will > output 'Z' (which is equal to UTC) when there is no timezone, whereas it > should output nothing (a date/time/dateTime without a timezone cannot be > assumed to be UTC: it's timezone must be considered unknown). But this > is fixed in 8.6 (see the last point in > http://www.saxonica.com/documentation/changes/intro86/xslt86.html), > along with support for [ZN] which outputs the timezone name instead of > the numerical offset - eg EST instead of -05:00. Although for this to > work correctly country should be specified also. > > Any idea when Saxon will be upgraded? > > Adrian > > > > > > > > -- > You receive this message as a subscriber of the [hidden email] mailing list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws > > > -- Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
CONTENTS DELETED
The author has deleted this message.
|
Administrator
|
Michael,
What persistence layer are you using? Is it the default one (eXist)? And where do you see that the last modified is 5 hours in the future? Is it on the summary page, or by looking at data in the database? Alex On Mon, Jul 26, 2010 at 8:28 AM, MichaelCap <[hidden email]> wrote: > > Hello, > > I am having an issue with Orbeon persisting the Date to the database. The > Create Date and Last Modified Date are 5 hours in the future. Is there a > place in the properties where I can change the timezone? > > Thank you, > > > Michael > -- > View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/incorrect-timezone-displayed-tp27813p2302481.html > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com. > > > -- > You receive this message as a subscriber of the [hidden email] mailing list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > -- Orbeon Forms - Web forms, open-source, for the Enterprise - http://www.orbeon.com/ My Twitter: http://twitter.com/avernet -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
CONTENTS DELETED
The author has deleted this message.
|
Administrator
|
Michael,
I have been looking at this on MySQL (as the Oracle support is in Orbeon Forms PE). In the persistence layer, we adjust the timezone to be UTC. But then, we it is parsed by the SQL processor, the timezone is not taken into account, and the time is assumed to be local time. So I changed the persistence layer not to adjust the time to UTC. Now the timestamp is stored correctly in MySQL, and when you go to the summary page it shows in local time (based on the timezone on the server). I made this change in both the MySQL and Oracle persistence layers. You can give a shot to the next nightly build, and you'll let me know if it works for you. For reference, the bug is: http://forge.ow2.org/tracker/index.php?func=detail&aid=315221&group_id=168&atid=350207 Alex On Mon, Jul 26, 2010 at 6:30 PM, MichaelCap <[hidden email]> wrote: > Alex, > I am using the Oracle persistence layer and I notice the time difference > when I look at the database entries. > Michael > On 2010-07-26, at 8:16 PM, Alessandro Vernet [via Orbeon Forms (ops-users)] > wrote: > > Michael, > > What persistence layer are you using? Is it the default one (eXist)? > And where do you see that the last modified is 5 hours in the future? > Is it on the summary page, or by looking at data in the database? > > Alex > > On Mon, Jul 26, 2010 at 8:28 AM, MichaelCap <[hidden email]> wrote: >> >> Hello, >> >> I am having an issue with Orbeon persisting the Date to the database. The >> Create Date and Last Modified Date are 5 hours in the future. Is there a >> place in the properties where I can change the timezone? >> >> Thank you, >> >> >> Michael >> -- >> View this message in context: >> http://orbeon-forms-ops-users.24843.n4.nabble.com/incorrect-timezone-displayed-tp27813p2302481.html >> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com. >> >> >> -- >> You receive this message as a subscriber of the [hidden email] mailing >> list. >> To unsubscribe: mailto:[hidden email] >> For general help: mailto:[hidden email]?subject=help >> OW2 mailing lists service home page: http://www.ow2.org/wws >> >> > -- > Orbeon Forms - Web forms, open-source, for the Enterprise - > http://www.orbeon.com/ > My Twitter: http://twitter.com/avernet > > > -- > You receive this message as a subscriber of the [hidden email] mailing list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > > ________________________________ > View message @ > http://orbeon-forms-ops-users.24843.n4.nabble.com/incorrect-timezone-displayed-tp27813p2303049.html > To start a new topic under Orbeon Forms (ops-users), email [hidden email] > To unsubscribe from Orbeon Forms (ops-users), click here. > > > ________________________________ > View this message in context: Re: incorrect timezone displayed > Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com. > > > -- > You receive this message as a subscriber of the [hidden email] mailing > list. > To unsubscribe: mailto:[hidden email] > For general help: mailto:[hidden email]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > -- Orbeon Forms - Web forms, open-source, for the Enterprise - http://www.orbeon.com/ My Twitter: http://twitter.com/avernet -- You receive this message as a subscriber of the [hidden email] mailing list. To unsubscribe: mailto:[hidden email] For general help: mailto:[hidden email]?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Free forum by Nabble | Edit this page |