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 |
|---|
| 02-APR-25 08.13.29.225922 +01: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') |
|---|
| 2025-04-02 08:13:29.227327 +01:00 |
SELECT CURRENT_TIMESTAMP FROM DUAL;
| CURRENT_TIMESTAMP |
|---|
| 02-APR-25 03.13.29.228330 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') |
|---|
| 2025-04-02 03:13:29.234240 -04:00 |
SELECT SYSTIMESTAMP AT LOCAL FROM DUAL;
| SYSTIMESTAMPATLOCAL |
|---|
| 02-APR-25 03.13.29.235611 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') |
|---|
| 2025-04-02 03:13:29.237475 -04:00 |