varchar to date
From: longinus <longinus_at_zeus.polsl.gliwice.pl>
Date: Tue, 27 Nov 2001 22:56:58 +0100
Message-ID: <3C040C2A.36EC3B0B_at_zeus.polsl.gliwice.pl>
Date is stored in 'VARCHAR' field.
SQL> select min(end_date)
[Quoted] 15.10.2001
Date: Tue, 27 Nov 2001 22:56:58 +0100
Message-ID: <3C040C2A.36EC3B0B_at_zeus.polsl.gliwice.pl>
Date is stored in 'VARCHAR' field.
SQL> select min(end_date)
brings:
MIN(END_DA
[Quoted] 15.10.2001
[Quoted] [Quoted] 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 - 22:56:58 CET