RE: Oracle and DST changes

From: Malpass, Nancy <nancy.malpass_at_cingular.com>
Date: Thu, 25 Jan 2007 10:34:49 -0600
Message-ID: <7666881061F0C34BAC4EF37E856883F0D5726B@ad01msxmb014.US.Cingular.Net>

What I have found on this topic so far is:

DST patch is included in 10.2.0.3 patchset 2.

You should plan on patching your 10G databases because 10G dictionary has TIMEZONE data types-can use 1-off 3.

You don't have to patch your clients if you are JDBC thin client 4.

If you have an application like a calender - that uses timezones you will want to patch 9i
5.

You will want to patch 9i databases if you use the timezone data types
6.

Prior to 9i these data types were not valid so - no need to patch prior releases
7.

march 11th is the majic date when we start DST this year and from now on
8.

If you don't patch the world will not end but you could see strange time/date calcs and you would have to clean data after the patch 9.

there are many notes on metalink as was previously mentioned - i have eaten thru several looking for what makes sense - there is a lot to digest though.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johan Muller Sent: Wednesday, January 24, 2007 2:01 PM To: Allen, Brandon
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle and DST changes

I forgot to add:

Put 'Daylight' into the the filter box to pull out the future scheduled conferences.

On 1/24/07, Allen, Brandon < Brandon.Allen_at_oneneck.com <mailto:Brandon.Allen_at_oneneck.com> > wrote:

Thanks for the tip!

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johan Muller

	Sent: Wednesday, January 24, 2007 12:06 PM
	To: rajendra.pande_at_ubs.com
	Cc: oracle-l_at_freelists.org 
	
	Subject: Re: Oracle and DST changes
	

	

	This link for future presentations by Oracle could be of some

help; I missed the one scheduled for to-day.

https://conference.oracle.com/imtapp/app/wel_public_mtgs.uix?bajaPage=fi lterField=MEETING_TITLE%24filterValue=%24gotoVal=1

On 1/24/07, Johan Muller <johan.muller_at_gmail.com> wrote:

Try this link - it gives a summary of the whole mess.

http://blogs.oracle.com/otn/stories/storyReader$367

		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
		On Behalf Of Pande, Rajendra
		Sent: Wednesday, January 24, 2007 10:43 AM 
		To: mgogala_at_verizon.net; wjwagman_at_ucdavis.edu
		Cc: Thomas.Mercadante_at_labor.state.ny.us ;
gkatteri_at_fastmail.fm; Mark
		Strickland; John.Fedock_at_us.kline.com;
oracle-l_at_freelists.org 
		Subject: RE: Oracle and DST changes
		
		So how does that help..
		Unless of course all you are dealing with are
databases,clients and data  in
		Arizona time zone. :)
		
		Note that this DST change impacts the whole world as
soon as you are doing a 
		date calculation using US time zones. No matter where

you live.

		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org [mailto:
oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ]
		On Behalf Of Mladen Gogala
		Sent: Wednesday, January 24, 2007 8:59 AM
		To: wjwagman_at_ucdavis.edu
		Cc: Thomas.Mercadante_at_labor.state.ny.us;
gkatteri_at_fastmail.fm; Mark
		Strickland; John.Fedock_at_us.kline.com;
oracle-l_at_freelists.org
		Subject: Re: Oracle and DST changes
		
		On 01/23/2007 11:52:37 AM, William Wagman wrote:


		> Greetings,

		>

		> I have been looking at the Metalink notes and am not

clear I understand 


		> when it becomes necesary to upgrade the clients. If

one is only using


		> the networking pieces of the clients and sqlplus is it

going to be


		> necessary to upgrade the client in that case. I guess

the general 


		> question is, what client pieces will require the

upgrade?


		>

		
		
		You should move to Arizona, it doesn't have DST. It has
plenty of daylight
		as it is, and
		it is one of the few states that doesn't implement DST. 
		
		--
		Mladen Gogala
		http://www.mladen-gogala.com 
		
		--
		http://www.freelists.org/webpage/oracle-l
		
		
		
		Please do not transmit orders or instructions regarding
a UBS account by
		e-mail. The information provided in this e-mail or any
attachments is not an
		official transaction confirmation or account statement.
For your protection, 
		do not include account numbers, Social Security numbers,
credit card
		numbers, passwords or other non-public information in
your e-mail. Because
		the information contained in this message may be
privileged, confidential, 
		proprietary or otherwise protected from disclosure,
please notify us
		immediately by replying to this message and deleting it
from your computer
		if you have received this communication in error. Thank

you.

		UBS Financial Services Inc.
		UBS International Inc.
		
		--
		http://www.freelists.org/webpage/oracle-l
		
		
		




	-- 
	Johan Muller
	Oracle DBA
	(214) 676 2147 anytime.
	
	"I love deadlines. I like the whooshing sound they make as they
fly by."
	Douglas Adams 
	Privileged/Confidential Information may be contained in this

message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

-- 
Johan Muller
Oracle DBA
(214) 676 2147 anytime.

"I love deadlines. I like the whooshing sound they make as they fly by."
Douglas Adams 

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 25 2007 - 10:34:49 CST