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!

TO_TIMESTAMP

Arif2018Jan 18 2021

i am trying to use this function to get the date which json supports ,
[code]
SELECT TO_UTC_TIMESTAMP_TZ('01-JAN-2021') FROM DUAL;
[/code]

i am getting the ORA-00904 as invalid identifier. how do i specify the dates in zulu format. couple of ways i tried in payload , but how to tell the consuming service people which format to use.

This post has been answered by Solomon Yakobson on Jun 9 2021
Jump to Answer
Comments
Post Details
Added on Jan 18 2021
10 comments
1,418 views