alter session set time_zone = 'Europe/Brussels'Statement processed.
alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FF3TZH:TZM'Statement processed.
alter session set nls_timestamp_format='YYYY-MM-DD HH24:MI:SS.FF3'Statement processed.
create table tmp (
ts timestamp,
ts_tz timestamp with time zone,
ts_ltz timestamp with local time zone
)Table created.
insert into tmp values (timestamp '2020-10-25 02:30:00+02:00',timestamp '2020-10-25 02:30:00+02:00',timestamp '2020-10-25 02:30:00+02:00')1 row(s) inserted.
insert into tmp values (timestamp '2020-10-25 02:30:00+01:00',timestamp '2020-10-25 02:30:00+01:00',timestamp '2020-10-25 02:30:00+01:00')1 row(s) inserted.
select to_char(ts),to_char(ts_tz),to_char(ts_ltz),to_char(ts_ltz,'YYYY-MM-DD HH24:MI:SS.FF3 TZR TZD') from tmp| TO_CHAR(TS) | TO_CHAR(TS_TZ) | TO_CHAR(TS_LTZ) | TO_CHAR(TS_LTZ,'YYYY-MM-DDHH24:MI:SS.FF3TZRTZD') | 2020-10-25 02:30:00.000 | 2020-10-25 02:30:00.000+02:00 | 2020-10-25 02:30:00.000 | 2020-10-25 02:30:00.000 EUROPE/BRUSSELS CEST | 2020-10-25 02:30:00.000 | 2020-10-25 02:30:00.000+01:00 | 2020-10-25 02:30:00.000 | 2020-10-25 02:30:00.000 EUROPE/BRUSSELS CET |
|---|