APEX

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!

APEX19.1, robust timestamp format for web source module's data profile

PaavoNov 29 2019 — edited Nov 30 2019

When using WSM web source module as source for report, then how avoid failing to : ORA-01882: timezone region not found

What is the format for the timestamp like this?

"end_time":"2019-11-18T10:11:17+02:00"

Is there timestamp format which could tolerate both syntaxes with zone and with offset?

"end_time":"2019-11-18T08:09:24.651Z"

"end_time":"2019-11-18T10:11:17+02:00"

Of course by defining the field in WSM's dataprofile as Varchar2 it doesn't give errors, but then the IR report doesn't recognize that it is timestamp.

Also the timestamp format should tolerate the following:

"end_time":"2019-09-04T07:52:36Z"

Also good pointers to wsm data profile format trickery doc/blogs are welcome

rgrds Paavo

This post has been answered by Carsten Czarski-Oracle on Nov 29 2019

Jump to Answer

Added on Nov 29 2019

#apex, #apex-discussions

6 comments

333 views