Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VARCHAR2 to DATE Conversion Error
The most sensible thing I've said in a long time :0(
Richard
Richard Foote wrote:
>
> "Mr. M" wrote:
> >
> > select to_char(to_date('August 10th 2002', 'Month DDth YYYY'),
> > 'DD-MON-YYYY')
> > from dual
> >
> > returns
> >
> > ERROR at line 1:
> > ORA-01841: (full) year must be between -4713 and +9999, and not be 0
> >
> > Uhhh????