Re: Why does the year 2000 do this?

Why do you have two nested to_dates. You only need to convert a string to a date once, and nesting usually goes wrong.

Hth,

Sybrand Bakker, Oracle DBA

"Sean" <dolans_at_my-deja.com> wrote in message news:8cj23p$qgb$1_at_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:26:34 CDT