The 'th' symbol isn't recognized, so you should rather format
your date to enter 'August 10 2002'.
HTH
Regards,
--
----------------------------------------------------------------------------
----
Celine Armanet - Division ORACLE
EPICENTRE - 529 Route des Vernes 74370 PRINGY
Tel. : +33 04 50 09 7000
Fax : +33 04 50 66 92 19
E-Mail : carmanet_at_epicentre.fr
----------------------------------------------------------------------------
----
"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:17:52 CDT
