RE: DST

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <Brandon.Allen@xxxxxxxxxxx>, <joe_dba@xxxxxxxxxxx>, <oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 5 Feb 2007 14:07:48 -0500

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@xxxxxxxxxxx
x72546
904  727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Monday, February 05, 2007 1:36 PM
To: joe_dba@xxxxxxxxxxx; oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.

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


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


Other related posts: