SQL*Loader help

Hi,
Hai I am very much new to Oracle. I am trying to load data into a table using SQL*Loader and i getting error while it is using the data format.
the format used in data file is "Sep 6 2001 12:00:00:000AM"
and when i used to_date( :accountDate, 'YYYY-MM-DD HH:MI:SS AM or PM') function it throws me an exception like
"ORA-01821: date format not recognized". so anybody can help me to insert data with out changing the data file, whould be really helpfull
thanks
vijay

Quote:

---

Originally posted by vijay321
... the format used in data file is "Sep 6 2001 12:00:00:000AM"
and when i used to_date( :accountDate, 'YYYY-MM-DD HH:MI:SS AM or PM') ...

---

Change that to:

Code:

---

to_date( :accountDate, 'Mon DD YYYY hh:mi:ss":000"AM')

---

and you'll be fine.