Re: DAte conversion

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