My Oracle Support Banner

USA 2007 Daylight Saving Time (DST) Compliance for Oracle Server Technologies Products (Doc ID 397281.1)

Last updated on AUGUST 24, 2021

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.

Purpose

This is archived content made available during the USA DST 2007 update (DSTv3 and DSTv4).
If you are looking for information on applying DStv4 for upgrades to 10.2.0.4, 11.1.0.6 or 11.1.0.7 please see
<Note 553812.1> Actions for the DSTv4 update in the 10.2.0.4 patchset
<Note 829734.1> Actions for the DSTv4 update in the 11.1.0.6 base release
<Note 568125.1> Actions for the DSTv4 update in the 11.1.0.7 patchset
These notes are more effective and better to use for DST during upgrades.

For information about newer DST updates available, and which time zone definitions are updated, see the following note: <Note 412160.1> Updated Time Zones in Oracle Time Zone File patches




The Energy Policy Act of 2005 was signed into law in August 2005 to extend daylight saving time. Beginning in 2007, daylight saving time in the U.S. will begin on the second Sunday in March and end the first Sunday in November rather than beginning on the first Sunday in April and ending the last Sunday in October, as it did in the past.

Under the new rules for 2007, DST will start on March 11, 2007 end on November 04, 2007. As a result the database may report incorrect time zone data between 03/11/2007 - 04/01/2007 and between 10/28/2007 - 11/04/2007 (and on different dates in subsequent years), unless the required patches are applied.

This change affects Canada as well. Mexico is still using the old DST rules.

Scope

This note describes the impact of these changes for the Oracle Server Technologies Products and 3rd party products that work with these and Operating Systems on which these run. For information on Oracle Applications please refer to:

<Note:403659.1> Oracle Applications: Daylight Saving Time Changes in 2007


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
 
 I. IMPACT ON ORACLE DATABASE AND FUSION MIDDLEWARE PRODUCTS
 1. Oracle DATABASE & client software
 2. Oracle JVM (OJVM)
 3. Oracle Application Server (AS)
 4 Enterprise Manager 9.2, Grid Control 10gR1 and 10gR2, DatabaseControl 10.x
 5. Other Oracle Products
 5.1 Oracle Forms
 5.2 Oracle Reports
 5.3 Oracle Universal Installer (OUI), Database Configuration Assistant (DBCA) and other JRE based tools
 5.4 Business Intelligence
 5.5 Oracle Lite
 5.6TimesTen
 5.7 SleepyCat
 5.8 Oracle Access Manager (OAM) (aka OBLIX)
 5.9 Collaboration Suite
 5.10 Sunopsis
 5.11 Oracle Internet Directory (OID)
 5.12 Oracle Virtual Directory (OVD)
 5.13 Oracle Identity Manager OIM (aka Thor/Xellerate)
 5.14 InnoDB
 
5.15 Content Services / Content DB (includes Context Media)
 5.16 Oracle M2CE (Multimedia Communication Engine) (HotSip)
 5.17 Jdeveloper
 II. 3RD PARTY & PARTNER PRODUCTS
 III. OPERATING SYSTEMS
 IV. ORACLE AND OTHER RELATED DOCUMENTATION
References

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