Oracle 11g Release 2

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

CREATE TABLE test (dt DATE);
INSERT INTO test VALUES (SYSDATE);
1 rows affected

SELECT dt, TO_CHAR(dt, 'DD-MON-YYYY HH24:MI:SS') FROM test;


DT
TO_CHAR(DT,'DD-MON-YYYYHH24:MI:SS')


06-JUL-22
06-JUL-2022 05:47:20