Primary Note DST FAQ : Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches (Doc ID 412160.1)

This is a combination of [tz-announce] 2024a release & [tz-announce] 2023d release.

2024A Briefly:
     Kazakhstan unifies on UTC+5 beginning 2024-03-01.
     Palestine springs forward a week later after Ramadan.
     zic no longer pretends to support indefinite-past DST.
     localtime no longer mishandles Ciudad Juárez in 2422.

   Changes to future timestamps:
    Kazakhstan unifies on UTC+5.  This affects Asia/Almaty and Asia/Qostanay which together represent the eastern portion of the country that will transition from UTC+6 on 2024-03-01 at 00:00 to join the western portion.

https://mm.icann.org/pipermail/tz-announce/2024-February/000081.html

2023D Briefly:
     Ittoqqortoormiit, Greenland changes time zones on 2024-03-31.
     Vostok, Antarctica changed time zones on 2023-12-18.
     Casey, Antarctica changed time zones five times since 2020.
     Code and data fixes for Palestine timestamps starting in 2072.
     A new data file zonenow.tab for timestamps starting now.

   Changes to future timestamps:
    Ittoqqortoormiit, Greenland(America/Scoresbysund) joins most of the rest of Greenland's timekeeping practice on 2024-03-31, by changing its time zone from -01/+00 to -02/-01 at the same moment as the spring-forward transition.  Its clocks will therefore not
     spring forward as previously scheduled.  The time zone change reverts to its common practice before 1981.

https://mm.icann.org/pipermail/tz-announce/2023-December/000080.html

Changes included in TZDATA2023C

Full details are here

https://mm.icann.org/pipermail/tz-announce/2023-March/subject.html

Release 2023c - 2023-03-28 12:42:14 -0700

Changes to past and future timestamps

Model Lebanon's DST chaos by reverting data to tzdb 2023a.

Release 2023b - 2023-03-23 19:50:38 -0700

Changes to future timestamps

This year Lebanon springs forward April 20/21 not March 25/26.

[This was reverted in 2023c.]

 

Release 2023a - 2023-03-22 12:39:33 -0700

Briefly:

Egypt now uses DST again, from April through October.

This year Morocco springs forward April 23, not April 30.

Palestine delays the start of DST this year.

Much of Greenland still uses DST from 2024 on.

America/Yellowknife now links to America/Edmonton.

tzselect can now use current time to help infer timezone.

The code now defaults to C99 or later.

Fix use of C23 attributes.

Changes included in tzdata2022f & tzdata2022g
--The 2022f release of the tz code and data is available.

https://mm.icann.org/pipermail/tz-announce/2022-October/000075.html

This release contains the following changes. The most urgent one is the

change for Chihuahua, Mexico which affects timestamps starting Sunday.

Briefly:

Mexico will no longer observe DST except near the US border.

Chihuahua moves to year-round -06 on 2022-10-30.

Fiji no longer observes DST.

Move links to 'backward'.

In vanguard form, GMT is now a Zone and Etc/GMT a link.

zic now supports links to links, and vanguard form uses this.

Simplify four Ontario zones.

Fix a Y2438 bug when reading TZif data.

Enable 64-bit time_t on 32-bit glibc platforms.

Omit large-file support when no longer needed.

In C code, use some C23 features if available.

Remove no longer-needed workaround for Qt bug 53071.

Changes to future timestamps

Mexico will no longer observe DST after 2022, except for areas

near the US border that continues to observe US DST rules.

On 2022-10-30 at 02:00 the Mexican state of Chihuahua moves

from -07 (-06 with DST) to year-round -06, thus not changing

its clocks that day. The new law states that Chihuahua

near the US border no longer observes US DST.

Fiji will not observe DST in 2022/3.

For now, assume DST is suspended indefinitely.

--The 2022g release of the tz code and data is available.

https://mm.icann.org/pipermail/tz-announce/2022-November/000076.html

The northern edge of Chihuahua changes to US timekeeping. Much of Greenland stops changing clocks after March 2023.

Changes included in TZDATA2022E & TZDATA2022D
2022e:

Jordan and Syria are abandoning the DST regime and are changing to permanent +03, so they will not fall back from +03 to +02 on 2022-10-28.

https://mm.icann.org/pipermail/tz-announce/2022-October/000074.html

2022d:

Palestine now springs forward and fall back at 02:00 on the first Saturday on or after March 24 and October 24, respectively.

https://mm.icann.org/pipermail/tz-announce/2022-September/000073.html

North Korea switches back from +0830 to +09 on May 2018- Impact on Oracle RDBMS <Note 2428170.1>

Brazil to Start DST on November From 2018 Onwards- Impact on Oracle RDBMS <Note 2331560.1>

Fiji ends DST on 14 January 2018 - Impact on Oracle RDBMS <Note 2331560.1>