Skip to Main Content

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, Tomcat9, timestamp

Paul JorstadDec 13 2019 — edited Dec 16 2019

Hello, I have a Ords 19.1 running on a Tomcat9. I have a REST service taking a timestamp type parameter. As I understand the timestamp format defaults to UTC timezone. Hence, it's not possible to send time zone information. As a result, the timestamp data is saved in the database with 2 more hours, as the timezone here is UTC+1 (and 1 hour more due to winter time). Hence, if I send a value of "1995-06-02T09:29:11.002Z" with the REST service, the date will be saved as 1995-06-02T11:29:11.

--> Is there a way, a setting or whatever, to make Tomcat/Ords save the timestamp (time) as I send it? All infrastructure is in the same location, the database NLS setting is correct, and should not be changed.

Comments
Post Details
Added on Dec 13 2019
2 comments
1,373 views