RE: Daylight Savings Time in 2007
And also http://www1.ibm.com/support/docview.wss?rs=0&context=SSGU5D&context=SSHM MC&context=SSGU8G&context=SSGKNY&context=SSGU5Y&context=SSCRW7&context=S SGHZP&context=SSVT2J&dc=D600&uid=swg21248851&loc=en_US&cs=utf-8&lang= I haven't had any luck getting the jtzu thing to work with 9.4, but it appears to work find with 10.0. DC > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Jean Georges Perrin > Sent: Tuesday, December 19, 2006 9:09 AM > To: tomcaml@yahoo.com; informix-list@iiug.org > Subject: RE: Daylight Savings Time in 2007 > > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list