TO_DATE transformation

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:00:16 CST