Daylight Savings Time in 2007
This was sent to me earlier - Is there a link or patch specific to Informix out there that someone is aware of? Thanks in advance - Tom =================== Following describes the problem we might face: In the United States the start and end of daylight savings times are being changed in 2007. Daylight savings time will now start on March 11, 2007 (rather than early April) and will end on November 4, 2007 (rather than late October). Canada has also decided to follow the same schedule. This may impact your databases so read on. DB2, and other data servers, rely on the operating system clock to get the current date and time. There will of course be an operating system patch that you will have to apply to virtually all operating systems so that they will know of the time change. And internally, logs don't use time zone information (in DB2, Oracle or any other DB that I'm aware of) so there is no problem there. But there is one more issue to know about. Java SDK and JRE need a special patch. Without this patch your Java applications that work with timestamps will display the wrong time during the weeks of the changed DST. And if the Java application uses that time stamp (for scheduling purposes for example) they will behave incorrectly during this extended DST time. This includes your own Java Applications (and your JDBC applications) as well as the DB2 Control Center and Query Patroller.
See: http://www.iiug.org/resources/articles/dls_2007.html > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Tuesday, December 19, 2006 17:02 > To: informix-list@iiug.org > Subject: Daylight Savings Time in 2007 > > This was sent to me earlier - Is there a link or patch specific to > Informix out there that someone is aware of? Thanks in advance - Tom > =================== > Following describes the problem we might face: > > In the United States the start and end of daylight savings times are > being changed in 2007. Daylight savings time will now start on March > 11, > 2007 (rather than early April) and will end on November 4, 2007 (rather > than late October). Canada has also decided to follow the same > schedule. > This may impact your databases so read on. > > DB2, and other data servers, rely on the operating system clock to get > the current date and time. There will of course be an operating system > patch that you will have to apply to virtually all operating systems so > that they will know of the time change. And internally, logs don't use > time zone information (in DB2, Oracle or any other DB that I'm aware > of) > so there is no problem there. But there is one more issue to know > about. > Java SDK and JRE need a special patch. Without this patch your Java > applications that work with timestamps will display the wrong time > during the weeks of the changed DST. And if the Java application uses > that time stamp (for scheduling purposes for example) they will behave > incorrectly during this extended DST time. This includes your own Java > Applications (and your JDBC applications) as well as the DB2 Control > Center and Query Patroller. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list