Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DST - its 20070215 and the patches are still in flux.

RE: DST - its 20070215 and the patches are still in flux.

From: <>
Date: Fri, 16 Feb 2007 08:18:51 -0500
Message-ID: <>

Yes, I did the version 3 thing, and I'm putting version 4 in now. The queries I found to check this on Oracle 9 return 0 with version 4 files... so I am looking for version 4 test queries that show version 4. I'm also looking for the client side files. Do you know where they are?    

Version 1, 2, 3 query for Oracle 9: Nothing for version 4.  

select case COUNT(DISTINCT(tzname))

         when 183 then 1

         when 355 then 1

         when 347 then 1

         when 377 then 2

         when 186 then

           case COUNT(tzname)

             when 636 then 2

             when 626 then 3

             else 0


         when 185 then 3

         when 386 then 3

         when 387 then

           case COUNT(tzname)

             when 1438 then 3

             else 0


         else 0

       end VERSION

  from v$timezone_names;  

Joel Patterson
Database Administrator
904 727-2546

[] On Behalf Of Paul Drake Sent: Thursday, February 15, 2007 8:58 PM To: oracle-l
Subject: DST - its 20070215 and the patches are still in flux.  

I checked in on Note:397281.1 again today and found that Patch 5632264 has changed.
I don't get this.
Some people only get downtime windows once a month and have to test these patches out prior to applying them to production. So at what point is Oracle going to say "Ok. That's it. We're done. No more changes to DST patches. Go with it." Today is Feb 15th. The time change occurs on March 11th.

This act was passed in the year 2005.

The Canadian changes were not made in the calendar year 2005. Ok. I don't know when such changes were made. What I do know is that there is just over 3 weeks remaining until showtime and the script isn't written yet.

"The Canadian changes are only available in the the more recent
version-4. This version-4 of the time zone files is available through a one-off patch for bug 5632264
<> ,"

"If you do not use any of the time zones that are updated in version-4
of the time zone files there is no need to specifically apply this, and you can just use version-3, which is more widely available at this moment."

I didn't take the course whereby I get to predict future usage patterns of an application.
So I guess that I take today's patch with version-4 time zones for and run with it (and hope that it doesn't change again).

No version-5, please. No updates. Thanks.


Received on Fri Feb 16 2007 - 07:18:51 CST

Original text of this message