Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name (date_column DATE);
INSERT INTO table_name (date_column)
VALUES (DATE '2022-11-22' + INTERVAL '12:34:56' HOUR TO SECOND);
1 rows affected

-- DUMP outputs the byte values:
-- Century + 100
-- Year-of-century + 100
-- Month
-- Date
-- Hour + 1
-- Minute + 1
-- Second + 1
SELECT DUMP(date_column) FROM table_name;


DUMP(DATE_COLUMN)


Typ=12 Len=7: 120,122,11,22,13,35,57


SELECT TO_CHAR(date_column, 'DD/MM/YYYY HH24:MI:SS') AS eu_format,
       TO_CHAR(date_column, 'MM/DD/YYYY HH24:MI:SS') AS us_format,
       TO_CHAR(date_column, 'YYYY-MM-DD"T"HH24:MI:SS') AS iso8601_format
FROM   table_name


EU_FORMAT
US_FORMAT
ISO8601_FORMAT


22/11/2022 12:34:56
11/22/2022 12:34:56
2022-11-22T12:34:56