Regarding date formats

From: Giridhar <gkodakalla_at_gmail.com>
Date: 30 Dec 2005 03:11:03 -0800
Message-ID: <1135941063.312382.290000@g43g2000cwa.googlegroups.com>

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 Received on Fri Dec 30 2005 - 05:11:03 CST