My Oracle Support Banner

Egypt Cancelled the Proposed DST Changes in 2016 - Impact on RDBMS (Doc ID 2152400.1)

Last updated on JANUARY 13, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database - Standard Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Purpose

The Egyptian government changed its mind on short notice, and Africa/Cairo will not introduce DST starting 2016-07-07

This is updated in tzdata 2016f release

 

http://www.iana.org/time-zones/repository/releases/tzcode2016f.tar.gz

 

Hence, no exceptional DST Patch is required for Egypt, as of now

 

To help you see if your database is affected by the Egyptian Government decision to not go to DST in 2015 and to see if you actually need a DST update (= "DST patch") or not for Oracle RDBMS.

The Egyptian authorities have just announced that the country will re-introduce Daylight Saving Time (DST) from this year onwards. This is from July 7 to the end of October, 27 Oct 24:00. no exceptional DST Patch is required for Egypt, as of now

For Questions/official statements about the DST change itself, please contact the Egyptian Government .

The affected timezones in Oracle are :

"Egypt" and "Africa/Cairo"

The changed timezone rules are in IANA Time Zone Data v. 2016e and 2016f contains the rules after cancelling the proposed DST (http://www.iana.org/time-zones ).

Scope

Anyone who may be using the Egyptian timezones

The Oracle kernel itself is also not impacted by the OS/system clock changes (or for that matter Oracle DST patches). <Note:1013279.6> How Does Daylight Savings Time Affect The Database Kernel?

Used abbreviations:
TZ: TimeZone
TSTZ: TimeStamp with Time Zone
TSLTZ: TimeStamp with Local Time Zone

 

The Egyptian government changed its mind on short notice, and Africa/Cairo will not introduce DST starting 2016-07-07

This is updated in tzdata 2016f release - http://www.iana.org/time-zones/repository/releases/tzcode2016f.tar.gz

 

Hence, no exceptional DST Patch is required for Egypt, as of now

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1) The DATE datatype and SYSDATE / SYSTIMESTAMP
 2) Stored data using TimeStamp with (Local) Time Zone datatype.
 3) TimeStamp with Time Zone columns are used, how do I see if Egyptian named timezones are stored?
 4) Database timezone and Session timezone
 5) Oracle RDBMS DST patches and this change.
 7) Java in the Database home
 8) Other Oracle software (Enterprise Manager , Oracle Applications etc)
 9) Will any data stored in DATE, TIMESTAMP, TIMESTAMP WITH (LOCAL) TIMEZONE columns be affected by changing the server OS timezone?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.