Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: VARCHAR2 to DATE Conversion Error

Re: VARCHAR2 to DATE Conversion Error

From: Richard Foote <Richard.Foote_at_oracle.com>
Date: Fri, 09 Aug 2002 20:05:36 +1000
Message-ID: <3D5393EF.3F767514@oracle.com>

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


Received on Fri Aug 09 2002 - 05:05:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US