Why does the year 2000 do this?

From: Sean <dolans_at_my-deja.com>
Date: Thu, 06 Apr 2000 22:12:21 GMT
Message-ID: <8cj23p$qgb$1@nnrp1.deja.com>

I have a package and then a procedure within that gets past a date in string format like : 1/1/2000

I then do a simple:

select to_date(to_date(strDateStart, 'MM/DD/YYYY'), 'DD-MON- YYYY') into datStart from dual;

Problem is that within PL/SQL, I keep getting the error: (full) year must be between -4793 and +9999 and not 0

But if I do 2001, it works PERFECTLY. Is there a problem with the year 2000 or am I doing it incorrectly?

Thanks,
Sean

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 06 2000 - 17:12:21 CDT