DAte conversion

From: longinus <longinus_at_zeus.polsl.gliwice.pl>
Date: Tue, 27 Nov 2001 22:56:08 +0100
Message-ID: <3C040BF8.CABD0451@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 - 15:56:08 CST