TSTZ: Why does Daylight Saving Time stops working beyond 2041?
Hi,
I know that Oracle-DB uses iana tzdata to calculate timezone-values. That works fine for the present and the near future, but it seems, that from 2041 DST is ignored.
As an example i picked 3 locations with DST-Transitions
- Canada Central
- Europe Berlin
- Israel
This statement converts June-1st for several years from UTC to the 3 timezones.
select
to_timestamp_TZ('01.06.2018 12:00:00 UTC', 'DD-MM-YYYY HH24:MI:SS TZR') AT TIME ZONE 'UTC' AS utc_timestamp,
to_timestamp_TZ('01.06.2018 12:00:00 UTC', 'DD-MM-YYYY HH24:MI:SS TZR') AT TIME ZONE 'Canada/Central' AS canada_central,
to_timestamp_TZ('01.06.2018 12:00:00 UTC', 'DD-MM-YYYY HH24:MI:SS TZR') AT TIME ZONE 'Europe/Berlin' AS europe_berlin,