TO_DATE problem

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 - 09:37:34 CST