Re: VARCHAR2 to DATE Conversion Error

Hi Mr M,

How's Mr T ?

It's the DDth that's causing the problem. I don't think you can use the DDth to create a date (to_date), only to convert from a date (to_char).

Then again, I could be wrong.

Cheers

Richard

"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????