Search notes:
Oracle JSON: Date Format
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"
-- }