Help with SQL-Loader and date field.

[Quoted] [Quoted] We are having to transfer some data from a non-Oracle database into one of our Oracle databases. I am having trouble with records which contain date fields and getting them loaded into Oracle.

[Quoted] The data records look like the following:

           85	           84	18-jan-1989 16:27:21     	           28
           85	           88	18-jan-1989 16:39:29     	           28
           85	           89	18-jan-1989 16:39:29     	           28

and the control file is defined as follows:

LOAD DATA
TRUNCATE
INTO TABLE asrtexpl(

	asrtmn_no CHAR TERMINATED BY WHITESPACE,
	asrtmn_exp CHAR TERMINATED BY WHITESPACE,
	asrt_eff DATE 'DD-mon-YYYY HH24:MI:SS' TERMINATED BY WHITESPACE,
	emp_id CHAR TERMINATED BY WHITESPACE) 

The error in the log file is:

Record 1: Rejected - Error on table ASRTEXPL, column ASRT_EFF. ORA-01840: input value not long enough for date format

The ASRT_EFF is defined as a DATE in the Oracle table.

Any help on how to load this record, and many more tables like it, would be great.

Thanks in advance.

-- 
[Quoted] Chad M. Hegerty (chad.hegerty_at_rossnutrition.com)
Ross Products Division - Abbott Laboratories