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 -> Re: Varchar to date

Re: Varchar to date

From: longinus <longinus_at_zeus.polsl.gliwice.pl>
Date: Wed, 28 Nov 2001 00:08:33 +0100
Message-ID: <3C041CF1.B68D119A@zeus.polsl.gliwice.pl>


no only two digit day or month!!!

Vincent Smith schrieb:
>
> Is there a single digit day or month in your data?
>
> "longinus" <longinus_at_zeus.polsl.gliwice.pl> wrote in message
> news:3C040C19.5E731F77_at_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 - 17:08:33 CST

Original text of this message

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