Need help - Error in SQLLOADER date format

From: Noira Hadi <r42317_at_email.sps.mot.com>
Date: Mon, 01 Nov 1999 16:26:19 +0800
Message-ID: <381D4EAB.DFF81FD1@email.sps.mot.com>

Hello,

I encountered the error message below while loading to Oracle using SQL* Loader:

Record 1: Rejected - Error on table TRDB_LOT_HISTS, column LHST_PROCESS_END_TIME.
ORA-01858: a non-numeric character was found where a numeric was expected

The actual script reads:
LHST_PROCESS_END_TIME POSITION(1609:1625) DATE "YY/MM/DD HH:MI:SS",

and the date data from flat file looks like: 98/11/20 14:20:18

Appreciate any help.

Regards,
hadi Received on Mon Nov 01 1999 - 02:26:19 CST