Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DAte conversion
there is such checking done by oracle, and those values are not
accepted.
Alexei VORONOV schrieb:
>
> Is there any 29.02.2001 or something like (e.g. 31.11.2001)?
>
> "longinus" <longinus_at_zeus.polsl.gliwice.pl> a écrit dans le message news:
> 3C040BF8.CABD0451_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 Wed Nov 28 2001 - 11:45:59 CST
![]() |
![]() |