Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TO_DATE transformation
OK your right about that... but that specific insert does not work on a test
table?
"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message
news:yyOn8.20936$Zr3.4024380_at_news1.news.adelphia.net...
> 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 - 16:51:56 CST