How to verify if the DST patch applied correctly or not.
453187Feb 9 2007 — edited Mar 10 2007Hi
I need to verify the DST patch I applied is working or not. Is there a way to check both OS and Oracle level. I am on Solaris 9 and
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
.
I ran the following query and it seems that the patch is not working.
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 08.00.00.000000000 AM US/EASTERN
Is there any other way to verfy both the OS and DB.
Thanks in Advance.