Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle and DST changes
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
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-lReceived on Thu Jan 25 2007 - 15:31:52 CST
![]() |
![]() |