Re: TO_DATE transformation

"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?
>
>

Quote the date mask and/or verify the correct syntax to_date('04/04/2001','DD/MM/YYYY')

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address