Database Administration (MOSC)

MOSC Banner

TSTZ: Why does Daylight Saving Time stops working beyond 2041?

edited Aug 3, 2018 8:59AM in Database Administration (MOSC) 6 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center