My Oracle Support Banner

Chile use DST Time Permanently until 2017 - Impact on Oracle RDBMS (Doc ID 1990337.1)

Last updated on JANUARY 07, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Oracle Database - Standard Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.

Purpose

This is archived content. This change is included in the DSTv24 (or later) update and this is available.
Please see Note 412160.1 Updated Time Zones in Oracle Time Zone File patches for information on the DST patches.

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

Chile currently observes Daylight Saving Time (DST).
Instead of turning the clocks back to standard time (one hour back on Sunday, April 26, 2015) as previously planned, the Chilean Government has decided not to make further changes to the clock in future years.
In other words, the daylight saving time observed till now will become the new Chilean Standard time. Chile/Continental will be UTC-03:00 hrs and Chile/EasterIsland will be UTC-05:00 hrs.

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

The affected timezones in Oracle are :

America/Santiago , Chile/Continental , Pacific/Easter , Chile/EasterIsland and Antarctica/Palmer

The changed timezone rules are in IANA Time Zone Data v. 2015a and later (http://www.iana.org/time-zones ).

Scope

Anyone who may be using the Chilean 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

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 Chilean 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.