Day light saving time change-ReOpening

>Hi,
>  The US is changing the day light saving time. We are using the TIMESTAMP 
> data types at different places.  Is there anything that we need to worry 
> regarding the day >light saving time change
>Thanks,
>Don. 
 
I saw this post a while ago. Now we have starting working on this. I
thought i will share my findings.
* Note 359145.1 - Impact of 2007 USA daylight saving changes on the
Oracle database
* Note 397281.1 - USA 2007 Daylight Saving Time (DST) Compliance for
Database and Fusion Middleware
* Note 391354.1 What Is The Impact Of US 2007 Daylight Savings Time
(DST) Changes For OID/AS?
* Note 77370.1  What are the effects of changing the system clock on an
Oracle Server instance?
* Note 340512.1 Timestamps & time zones - Frequently Asked Questions
* Bug 4689959 - DST RULE CHANGE IN US, NEED PATCHED TIMEZONE FILES
* Note 402742.1 - USA 2007 DST Changes: Frequently Asked Questions for
Oracle RDBMS
* Note 396225.1 - OTM - Daylight Savings Time Changes for 2007

Besides you have the following links too

http://sunsolve.sun.com/search/document.do?assetkey=1-26-102178-1
http://www.microsoft.com/windows/timezone/dst2007.mspx

Note 403311.1 - United States Time Zone Changes 2007: E-Business Suite
(EBS)
Note 357056.1 - Impact of changes to daylight saving time (DST) rules on
the Oracle database
Note 396387.1 - Workarounds when Database time zone patches are not
available for your patchset
Note 396426.1 - Effects on client and middle-tier of applying time zone
patches on the Oracle Database
Note 396670.1 - Usage of utltzuv2.sql before updating time zone files in
Oracle 9
Note 396671.1 - Usage of utltzuv2.sql before updating time zone files in
Oracle 10
Note 397770.1 - How to check if Oracle JVM is installed in the Database
Note 399832.1 - Workarounds when utltzuv2.sql patches are not available
for your patchset
Note 402316.1 - Database Time Zone Patching Strategy in the Enterprise
Note  : 396906.1 Patches to Update the Time Zone Transition Rules
Note  : 77370.1  What are the effects of changing the system clock on an
Oracle Server instance?

HTH
GovindanK
Certified DBA 
Learning Stops at ... Infinity
--
http://www.freelists.org/webpage/oracle-l

Other related posts: