Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DST

RE: DST

From: <Joel.Patterson_at_crowley.com>
Date: Mon, 5 Feb 2007 14:07:48 -0500
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B028F21DC@jax-mbh-01.jax.crowley.com>


Of course, metalink also says that it could be good to update just in case someone was to begin using the datatypes.

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
Sent: Monday, February 05, 2007 1:36 PM
To: joe_dba_at_hotmail.com; oracle-L_at_freelists.org Subject: RE: DST

Yes, that is an offset, but that doesn't mean that only offsets are used in your TSTZ columns (if you have any). If you're on 9.2, then you don't need to worry about the patches unless you're using TSTZ/TSLTZ columns in your app's schema/code somewhere, or plan to do so in the future. If you are using TSTZ/TSLTZ, then read all the notes, download the patch and run the utlzuv2.sql script after manually adding the 9 new timezones to your timezdif.csf file (see my previous posts for more detail on this). Yes, lots of us have dealt with this - please review all the Metalink Notes and archives of this list and then let us know if you still have any specific questions.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith

Has anybody dealt with this yet?

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.

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


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 05 2007 - 13:07:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US