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: Oracle and DST changes

Re: Oracle and DST changes

From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>
Date: Thu, 25 Jan 2007 16:31:52 -0500
Message-ID: <45B921C8.9080201@tufts.edu>


This actually turns out not to be true. I just applied the patch to a test db without shutting down and when I ran the confirmation sql I got the updated results:

SQL> select to_timestamp_tz('20070311 00:00:00 US/EASTERN','YYYYMMDD HH24:MI:SS TZR') + to_dsinterval('0 08:00:00') TEST from dual;

TEST



11-MAR-07 09.00.00.000000000 AM US/EASTERN (solaris 64-bit/oracle 10.1.0.4)

Joe

Allen, Brandon wrote:
  It also confirms that the timezone files are in
> fact only read at startup, so a restart is necessary for the new rules
> to take effect.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 25 2007 - 15:31:52 CST

Original text of this message

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