Skip to Main Content

Integration

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!

fn-bea:dateTime-to-string-with-format time zone issue

Vinnu_ksOct 30 2018 — edited Oct 22 2019

Hi All,

Function fn-bea:dateTime-to-string-with-format converts the date/time back to GMT, is there a way to stop it.

I am converting datetime to different timezone using below function

fn:adjust-dateTime-to-timezone(xs:dateTime('2018-10-31T03:54:47Z'))   - returns 2018-10-31T09:24:47+05:30

While trying to get hours and minutes from the generated date time using fn-bea:dateTime-to-string-with-format i was hoping to get 0924

fn-bea:dateTime-to-string-with-format("HHmm",fn:adjust-dateTime-to-timezone(xs:dateTime('2018-10-31T03:54:47Z'),()))   - returns 0354 instead

Is there a way to stop it converting it to GMt by default. Do we have any other function which does it.

Thanks

Vinod S.

Comments
Post Details
Added on Oct 30 2018
1 comment
975 views