Tutorial: U.S. Daylight Saving Time Changes

View PDF

DataDirect Connect Series for ODBC

The United States has planned a change to its Daylight Saving Time (DST) observance beginning in 2007. The Energy Policy Act of 2005 mandates that DST will start on the second Sunday in March and end on the first Sunday in November. For 2007, this means that DST will start and end on the following dates:

Start date: March 11
End date: November 4

DataDirect Technologies performs ongoing testing to ensure that all Connect Series for ODBC drivers work properly for all DST transitions. No changes were required in the drivers. If your application is sensitive to the change in DST, you must ensure that the operating system and database have been updated for the change in DST rules for 2007 and beyond. Refer to the following vendor links for details.

Operating Systems Versions with Updated Rules

AIX

http://www-03.ibm.com/servers/eserver/support/unixservers/news/2006/10/DSTupdate.html

HP-UX

11.23
http://www2.itrc.hp.com/service/patch/patchDetail.do?admit=-1335382922+1169650460980
+28353475&patchid=PHCO_34669&BC=main%7Csearch%7C&sel=%7Bhpux%3A11.23%2C%7D

11.22
http://www2.itrc.hp.com/service/patch/patchDetail.do?admit=-1335382922+1169650501930
+28353475&patchid=PHCO_34668&BC=main%7Csearch%7C&sel=%7Bhpux%3A11.11%2C%7D

11.0
http://www2.itrc.hp.com/service/patch/patchDetail.do?admit=-1335382922+1169650539461
+28353475&patchid=PHCO_34673&BC=main%7Csearch%7C&sel=%7Bhpux%3A11.00%2C%7D

Linux

Novell SUSE
http://www.novell.com/support/search.do?cmd=displayKC&docType=kc&externalId=3853518
&sliceId=SAL_Public&dialogID=16420376&stateId=0%200%2016422084

Red Hat
http://rhn.redhat.com/errata/RHEA-2006-0622.html%5Ct_blank

Microsoft Windows

http://www.microsoft.com/windows/timezone/dst2007.mspx

Other Operating System Vendors

Contact your vendor for information about system support for the U.S. DST changes.

Database Versions with Updated Rules

IBM DB2

http://www-1.ibm.com/support/docview.wss?uid=swg21248542

IBM Informix

http://www-1.ibm.com/support/docview.wss?uid=swg21248851

Microsoft SQL Server

http://www.microsoft.com/windows/timezone/dst2007.mspx

Oracle

Oracle MetaLink Documents

397281.1 - USA 2007 Daylight Saving Time (DST) Compliance for Database
359145.1 - Impact of 2007 USA daylight saving changes on the Oracle database

Sybase

http://www.sybase.com/detail?id=1048699

Other Database Vendors

Contact your vendor for information about database support for the U.S. DST changes.