Re: VARCHAR2 to DATE Conversion Error

From: Epicentre Team B Annecy <carmanet_at_epicentre.fr>
Date: Fri, 9 Aug 2002 12:35:41 +0200
Message-ID: <aj05s4$otj$1@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 - 05:35:41 CDT