It could also be that it is a date like 06.1.2000 and that won't work
either.
try 'D.M.YYYY' that might work.
Damien is correct store dates in date fields.
Jim
"Damien Salvador" <damien.salvador_at_via.ecp.fr> wrote in message
news:slrna08461.t6e.damien.salvador_at_zen.via.ecp.fr...
> On Tue, 27 Nov 2001 22:56:08 +0100, longinus
> <longinus_at_zeus.polsl.gliwice.pl> a écrit:
> >Date is stored in 'VARCHAR' field.
>
> >
> >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?????
>
> Are you sure ALL your dates are in the DD.MM.YYYY form ?
> Isn't there a MM.DD.YYYY date ? Maybe there is an invalid
> date in your column.
>
> Why don't you store your dates in a date column ?
>
>
> --
> Damien
>
Received on Tue Nov 27 2001 - 16:37:31 CST
