re: test for DST patching

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Thu, 8 Mar 2007 09:15:47 -0800 (PST)
Message-ID: <480980.43950.qm@web33213.mail.mud.yahoo.com>

Help,    

  The test for DST is not working:    

  SQL> select case to_number(to_char(to_timestamp_tz

            ('20070311 00:00:00 US/EASTERN','YYYYMMDD HH24:MI:SS TZR')
            + to_dsinterval('0 08:00:00'),'HH24'))
            when 8 then 'The patch has not been applied'
            when 9 then 'The patch has been applied correctly'
            else 'Error' end "TZTEST (RUN FROM DB HOME)"
       from dual;

TZTEST (RUN FROM DB HOME)

---

The patch has been applied correctly  

---

Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 08 2007 - 11:15:47 CST