Oracle Database Discussions

i saw a similar thread about migrating from db2 to oracle timestamp...
but i'm still having trouble...migrating from sybase ase to oracle...
here's my situation:

my bcp'd out .dat file has the datetime column in 24hr clock time (following is an example):
Oct 15 2004 11:23:30:000AM

my sqlldr control file has this in it for the date col:
WF_CREATION_DATE "TO_TIMESTAMP(:WF_CREATION_DATE, 'yyyy-mm-dd HH24:mi:ss.ff3')",

the generated sqlldr .sh file has the following variables set:
export NLS_DATE_FORMAT='Mon dd YYYY HH:mi:ssAM'
export NLS_TIMESTAMP_FORMAT='Mon dd YYYY HH:mi:ffAM'



i'm getting the msg, "Record 44: Rejected - Error on table PIONEER.FX_PH_PROCESS_INSTANCE, column WF_CREATION_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0"

i looked up oracle doc on the datetime 'format models' and saw this:
the total length of a datetime format model cannot exceed 22 characters"...
(which i don't understand...where will my seconds 'go' if not specified in the mask?)


what should i do?

thx!