Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_DATE problem
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
![]() |
![]() |