Re: VARCHAR2 to DATE Conversion Error

Please use this statement:

select to_char(to_date('August 10th 2002', 'Month DD"th" YYYY'),'DD-MON-YYYY') from dual

"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> wrote in message news:<aj05s4$otj$1_at_wanadoo.fr>...
> Sorry Mr. M, I made a (big) mistake!
>
> I think the problem comes from spaces...
> Try : "select TO_CHAR(SYSDATE, 'DAY DDTH MONTH YYYY') from dual", and see
> the result...
>
> Celine.
>
> "Mr. M" <mrm_at_nospamsorry.com> a écrit dans le message news:
> 1028886620.23187.0.nnrp-08.c2d92da9_at_news.demon.co.uk...
> > 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????
> >
> >
Received on Fri Aug 09 2002 - 09:49:29 CDT