Hi,
Please review the following two pl/sql blocks.
Our NLS_DATE_FORMAT is defined as DD-MON-RR.
------------------------------------------------------------
SQL> declare
 2  v date;
 3  begin
 4  select decode(0,-1,NULL,(to_date('05251932', 'MMDDYYYY'))) into v
from
dual;
 5  DBMS_OUTPUT.PUT_LINE(to_char(v,'DD-MON-YYYY'));
 6  end;
 7  /
-----------
25-MAY-2032
-----------
PL/SQL procedure successfully completed.

SQL> declare
 2  v date;
 3  begin
 4  select to_date('05251932', 'MMDDYYYY') into v from dual;
 5  DBMS_OUTPUT.PUT_LINE(to_char(v,'DD-MON-YYYY'));
 6  end;
 7  /
-----------
25-MAY-1932
-----------
PL/SQL procedure successfully completed.
------------------------------------------------------------

May i know why the first one is displaying value as 25-MAY-2032 instead
of
25-MAY-1932

Thanks
Giridhar