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

if you're dealing with files, it does just that already

sorosch

Hmmm - what does you mean with that:

thatJeffSmith-Oracle schrieb:

if you're dealing with files, it does just that already

Do you mean the query to save each tab when closing SQL Developer? So i have tiles of each tab - and that is very ugly.

i mean, any FILES you have open when you shut down sql developer, when you re-open the app, those files will be re-opened

sorosch

OK - that´s correct - when saving an open tab as a file then the FILE ist re-opened. But without saving the tab as a file this is not possible - or?

2693955

Yes, it does do this but does anyone know where the file/temp location of what has been open is located. The reason for the ask when I move to new computers or upgrading to a new version of SQL you lose those file tabs and a user has to take a screen pic to open them all over again and close the app to get whole again.

thanks Chris

SQL tabs.jpg

1 - 5

Post Details

Added on Jan 18 2021
10 comments
1,366 views