Re: Need help - Error in SQLLOADER date format

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Mon, 1 Nov 1999 10:39:30 -0800
Message-ID: <7vkmri$mc5$1@plo.sierra.com>

Some times the data does not contain leading zeros on month or day fields

ie, 01/21/99 02:49:01 shows up in your input data as: 1/21/99 2:49:01, which is not compatible with your input format.

Noira Hadi <r42317_at_email.sps.mot.com> wrote in message news:381D4EAB.DFF81FD1_at_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 - 12:39:30 CST