Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TO_DATE transformation
At a guess I would say that it isn't DD/MM but MM/DD (that is more common
in the US at least). Check your data and see if the rejected records have
values greater than 12 in that first spot. Or, it could just be bad data.
Reviewing the bad record file you set up should resolve the difference.
"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message
news:a7oa79$jcv$1_at_bob.news.rcn.net...
> This is for SQLLDR but Im testing it with an insert...
>
> I have date data that is in a text file that comes in looking like the
> following 04/04/2001 which is I remember correctly(Im at home and dont
have
> what I wrote at work with me) is in the form DD/MM/YYYY
>
> Im trying to insert this kind of record and I get errors. Here is what I
> did...
>
> Insert into Table(Date_Column)
> Values(TO_DATE('04/04/2001', DD/MM/YYYY);
>
> That does not work. I get errors. Cant remember what it was exactly...
> something about bad date format. I tried doing a to_char then a to_date
and
> got errors with that too.
>
> What do I do?
>
>
Received on Mon Mar 25 2002 - 17:39:10 CST