Search notes:

Oracle JSON: Date Format

JSON does not specify a date format to transmit dates.
Oracle uses the following date formats in JSON related functions:
select
   json_object(
      'dt1'   value  sysdate,
      'dt2'   value  systimestamp,
      'dt2'   value  cast (sysdate as timestamp with time zone)
       pretty
   ) obj
from
   dual;
--
-- OBJ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- {
--   "dt1" : "2024-02-23T14:34:03",
--   "dt2" : "2024-02-23T14:34:03.714600Z",
--   "dt2" : "2024-02-23T14:34:03.000000+01:00"
-- }

See also

Oracle SQL/JSON

Index