By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
ALTER SESSION SET TIME_ZONE='Europe/Paris';
SELECT TO_CHAR(
FROM_TZ(
TIMESTAMP '1970-01-01 00:00:00' + INTERVAL '86400' SECOND,
'UTC'
) AT TIME ZONE SESSIONTIMEZONE,
'YYYY-MM-DD HH24:MI:SS'
) AS ts
FROM DUAL
| TS |
|---|
| 1970-01-02 01:00:00 |
SELECT TO_CHAR(
(TIMESTAMP '1970-01-01 00:00:00 UTC' + INTERVAL '1' DAY)
AT TIME ZONE SESSIONTIMEZONE,
'YYYY-MM-DD HH24:MI:SS'
) AS ts
FROM DUAL
| TS |
|---|
| 1970-01-02 01:00:00 |