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 -> VARCHAR2 to DATE Conversion Error

VARCHAR2 to DATE Conversion Error

From: Mr. M <mrm_at_nospamsorry.com>
Date: Fri, 9 Aug 2002 10:52:46 +0100
Message-ID: <1028886620.23187.0.nnrp-08.c2d92da9@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 - 04:52:46 CDT

Original text of this message

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