Re: TO_DATE problem

From: Paul-Marc Marot <Paul-Marc.Marot_at_capway.com>
Date: Thu, 10 Dec 1998 17:10:52 +0100
Message-ID: <74ornq$c8v$1@minus.oleane.net>

You should put your date between quotes: TO_DATE('12/09/98', 'DD/MM/YY')

Paul-Marc Marot

Brad McBride a écrit dans le message <366FEABE.5245DE13_at_Axom.com>...
>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:10:52 CST