USA 2007 Daylight Saving Time (DST) Compliance for Oracle Server Technologies Products
(Doc ID 397281.1)
Last updated on AUGUST 24, 2021
Oracle Database - Enterprise Edition Information in this document applies to any platform.
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, 220.127.116.11 or 18.104.22.168 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 22.214.171.124 base release <Note 568125.1> Actions for the DSTv4 update in the 126.96.36.199 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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!