Oracle 21c
About Developer Oracle 19c Oracle 12c Technology Information Sitemap

Oracle JSON_SCALAR function
-- Oracle 21c: JSON_SCALAR Function 

SELECT 
  JSON_VALUE(JSON_SCALAR(current_timestamp), '$.timestamp()')
FROM
 DUAL
;

SELECT 
  JSON_SCALAR(to_timestamp_tz('2019-05-03 20:00:00 -8:30',
                              'YYYY-MM-DD HH24:MI:SS TZH:TZM'))
FROM
 DUAL
;



  Oracle 21c Index   Oracle Functions

  Lower Versions   11g Index   12c Index   11g Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: January 27th, 2023

  313