Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Varchar to date

Varchar to date

From: longinus <longinus_at_zeus.polsl.gliwice.pl>
Date: Tue, 27 Nov 2001 22:56:41 +0100
Message-ID: <3C040C19.5E731F77@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:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US