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

Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_DATE problem

Re: TO_DATE problem

From: Steven H. Meller <smeller_at_nospam.com>
Date: Wed, 16 Dec 1998 09:04:40 -0500
Message-ID: <3677bc43.0@stnws02.atl.mediaone.net>


Brad,
Be sure and enclose the date in quotes, as TO_DATE('12/09/98', ... HTH,
Steve
>> data over from the flat files. This is where my problem comes in. I am
>> having to work with a date that was stored in the flat file as (for
>> example) 12/09/98. I am trying to convert it into a usable Oracle date
>> by using the TO_DATE(12/09/98, 'MM/DD/YY') function but when I try this
>> I get an error that states, "ORA-01858: a non-numeric character was
>> found where a numeric was expected". This has been driving me nuts. Any
>> help that someone could provide will be greatly appriciated.
>>
>> Brad McBride
Received on Wed Dec 16 1998 - 08:04:40 CST

Original text of this message

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