Is there any 29.02.2001 or something like (e.g. 31.11.2001)?
"longinus" <longinus_at_zeus.polsl.gliwice.pl> a écrit dans le message news:
3C040BF8.CABD0451_at_zeus.polsl.gliwice.pl...
> Date is stored in 'VARCHAR' field.
> SQL> select min(end_date)
>
> brings:
>
> MIN(END_DA
> ----------
> 15.10.2001
>
> I want to convert end_date (VARCHAR) for date and choose the oldest
> one..
> SQL> select min(to_date(end_date,'DD.MM.YYYY'))
> reached';
> ERROR:
> ORA-01839: date not valid for month specified
>
> What is wrong?????
Received on Wed Nov 28 2001 - 12:19:28 CST
