Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Varchar to date
Is there a single digit day or month in your data?
"longinus" <longinus_at_zeus.polsl.gliwice.pl> wrote in message
news:3C040C19.5E731F77_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 Tue Nov 27 2001 - 16:50:13 CST