Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- Set the time zone on the client
ALTER SESSION SET TIME_ZONE = 'America/New_York';
SELECT SYSTIMESTAMP FROM DUAL;

SYSTIMESTAMP

07-NOV-24 10.03.34.624275 +00:00

SELECT TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
FROM   DUAL;

TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DDHH24:MI:SS.FFTZH:TZM')

2024-11-07 10:03:34.625940 +00:00

SELECT CURRENT_TIMESTAMP FROM DUAL;

CURRENT_TIMESTAMP

07-NOV-24 05.03.34.627310 AMERICA/NEW_YORK

SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
FROM   DUAL;

TO_CHAR(CURRENT_TIMESTAMP,'YYYY-MM-DDHH24:MI:SS.FFTZH:TZM')

2024-11-07 05:03:34.628491 -05:00

SELECT SYSTIMESTAMP AT LOCAL FROM DUAL;

SYSTIMESTAMPATLOCAL

07-NOV-24 05.03.34.629834 AMERICA/NEW_YORK

SELECT TO_CHAR(SYSTIMESTAMP AT LOCAL, 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
FROM   DUAL;

TO_CHAR(SYSTIMESTAMPATLOCAL,'YYYY-MM-DDHH24:MI:SS.FFTZH:TZM')

2024-11-07 05:03:34.630985 -05:00