ORDS, SODA & JSON in the Database

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!

ORDS - convert date to current time zone

Vanja KeglevićJul 30 2019 — edited Jul 31 2019

Hi,

is it possible to change ORDS behavior regarding the conversion of Oracle date type to text in json? Now it's returned in Zulu time zone, is it possible to just get it in current time zone?

For example my current time is "30.07.2019. 15:16:34" and I would like to get it as such in json.

Of course I can format it by myself with the to_char/to_date function, but I would like not to do that.

Kind regards

This post has been answered by thatJeffSmith-Oracle on Jul 30 2019

Jump to Answer

Added on Jul 30 2019

1 comment

496 views