Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dayTimeDuration operation results and fn:implicit-timezone()

707938Jun 22 2009 — edited Jun 23 2009

This should be simple, but I don't know if it's an issue with xquila, bdbxml or if it's something I am doing wrong in my xquery.

Problem is I need the classic unix/posix representation of seconds since ... you know, so while running in windows and issuing:

(current-dateTime() - xs:dateTime('1970-01-01T00:00:00')) div xs:dayTimeDuration('PT1S')

gives me a value 3 hours different from what system is giving me and when I issue

fn:implicit-timezone()

I get what I should -PT3H which is righ for my machine.

is this right? for the time being I am forcing it by adding (fn:implicit-timezone() div xdt:dayTimeDuration('PT1S')) * -1 to the result.

Is this the correct behavior?

This post has been answered by 522770 on Jun 23 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2009

Added on Jun 22 2009

#berkeley-db-xml

2 comments

2,786 views