incorrect timezone displayed

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

incorrect timezone displayed

Adrian Baker-2
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
Reply | Threaded
Open this post in threaded view
|

Re: incorrect timezone displayed

Alessandro  Vernet
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
Reply | Threaded
Open this post in threaded view
|

Re: incorrect timezone displayed

MichaelCap
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Re: incorrect timezone displayed

Alessandro  Vernet
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
Reply | Threaded
Open this post in threaded view
|

Re: incorrect timezone displayed

MichaelCap
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Re: incorrect timezone displayed

Alessandro  Vernet
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