Vendor homepage https://www.allroundautomations.com/products/pl-sql-developer/Product help there is no online verson, but release notes https://www.allroundautomations.com/products/pl-sql-developer/release-notes/ Config
Continue ReadingDate in ISO8601 Format in Oracle DB
Below the code example how to get date format as ISO8601. First example is current time zone. Second example is valid if your database is actually in UTC time zone. SELECT to_char(SYSTIMESTAMP, ‘YYYY-MM-DD”T”HH24:MI:SS.FF6TZH:TZM’) AS ISO8601 FROM dual; SELECT to_char(SYSTIMESTAMP, ‘YYYY-MM-DD”T”HH24:MI:SS.FF6″Z”‘) AS ISO8601_UTC_format FROM dual;
Continue Reading