Re: TO_DATE problem

I presume you are using SQL*Loader to load the flat files into the database.
The date column needs to go in as folows:

date_column DATE "DD-MM-YY"

Brad McBride wrote:

> Hello,
>
> I am working with converting a flat file database into an Oracle
> database in order to make our recordkeeping more efficient. So far,
> Oracle has been working great. I am now at a point where I have all of
> the test data working the way that it should and am ready to import the
> 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 Thu Dec 10 1998 - 10:25:25 CST