| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Day Light Savings Time in US
Looks like it will as well as DB2. Especially if the application is
using a calendar function. The IBM site has an interesting article on
it.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nancy Iles
Sent: Tuesday, November 28, 2006 7:30 PM
To: oracle-l_at_freelists.org
Subject: RE: Day Light Savings Time in US
Besides iAS & the database, what about the Java installed on the server
for
Oracle Apps? Will it have to be patched/upgraded also?
Regards,
Nancy Iles
Omni Hotels
----Original Message Follows----
From: "Pass, Stephanie" <Stephanie_Pass_at_cable.comcast.com>
Reply-To: Stephanie_Pass_at_cable.comcast.com
To: "Jesse, Rich" <Rich.Jesse_at_qg.com>,<oracle-l_at_freelists.org>
Subject: RE: Day Light Savings Time in US
Date: Tue, 21 Nov 2006 15:48:19 -0700
Yes. Are you being "proactive"???
It looks as though any 9i db that uses timestamps or any 10g db will require the patches (dictionary uses timestamps in 10g).
So far it looks as though the patches will change data too. All clients that access these systems will need to be patched so they will be able to see the timestamps correctly. It looks as though iAS will require patching too;. I'm still looking and will probably see other apps that will need to be patched as I dig.
My assumption is that the OS will require a patch so Oracle will know about the change. This is going to be sooo much fun to try and coordinate this change across our organization.
From: Jesse, Rich [mailto:Rich.Jesse_at_qg.com] Sent: Tuesday, November 21, 2006 12:11 PM To: Pass, Stephanie; oracle-l_at_freelists.org Subject: RE: Day Light Savings Time in US
Do you mean this?
http://www.freelists.org/archives/oracle-l/10-2006/msg00950.html
Note the lack of responses. :) My main question is with the TIMESTAMP datatypes in the Oracle-supplied schemas. Not sure how those are impacted, if at all.
GL!
Rich
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pass, Stephanie
Sent: Monday, November 20, 2006 6:17 PM
To: oracle-l_at_freelists.org
Subject: Q: Day Light Savings Time in US
I just started looking into the Day Light savings changes that will need to occur in Oracle before April. Both databases and clients will need to be changed if they are v9.x and especially 10.x. I haven't gotten far enough to see if any OS patches will need to occur.
Has anyone one the list started digging into it yet? I
Notes - 359145.1, 396426.1
Thanks!
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 29 2006 - 18:36:09 CST
 |
 |