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