Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Varchar to date
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