QUERY RESULT display timestamp with time zone as if it were in the time zone set for the session and ignores the timezone in the timestamp itself.
select
ts,
to_char(ts, 'YYYY-MM-DD HH24:MI:SSXFF2 TZR')
from (
select
from_tz(timestamp '2026-03-11 18:08:25', '5:00') ts
from
dual
)
QUERY RESULT:
2026-03-11 18:08:25.000 GMT+2 2026-03-11 18:08:25,00 +05:00
Built in SQLcl, SCRIPT OUTPUT shows correctly, i.e. error only in the QUERY RESULT.
version: 25.4.1 February 2026
OS: Ubuntu 24.04.4 LTS
QUERY RESULT display timestamp with time zone as if it were in the time zone set for the session and ignores the timezone in the timestamp itself.
QUERY RESULT:
2026-03-11 18:08:25.000 GMT+2 2026-03-11 18:08:25,00 +05:00
Built in SQLcl, SCRIPT OUTPUT shows correctly, i.e. error only in the QUERY RESULT.
version: 25.4.1 February 2026
OS: Ubuntu 24.04.4 LTS