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

22-JAN-26 11.14.59.685463 +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')

2026-01-22 11:14:59.687307 +00:00

SELECT CURRENT_TIMESTAMP FROM DUAL;

CURRENT_TIMESTAMP

22-JAN-26 06.14.59.688815 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')

2026-01-22 06:14:59.697483 -05:00

SELECT SYSTIMESTAMP AT LOCAL FROM DUAL;

SYSTIMESTAMPATLOCAL

22-JAN-26 06.14.59.698858 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')

2026-01-22 06:14:59.700223 -05:00