SQLLDR: date&time fields

From: dsmcd <dsmcd_at_uswestmail.net>
Date: Fri, 12 Oct 2001 02:51:38 GMT
Message-ID: <_Usx7.766$8H1.640118@news.uswest.net>

Hello...I'm a newbie to sqlldr so please bare with me.

One field in my table is a date&time field. The ctl file defines the field format as

"Mon DD YY HH24:MI:SS"

But for some records in the dat file, the date&time field does not a date, it ONLY has the time.

Sqlldr seems to handle loading a date&time field when there's just a date, but it considers a record to be bad when a date&time field has just a time.

In other words...

Any way to get Sqlldr to load
" 09:26:15"

into a field defined as
"Mon DD YY HH24:MI:SS"?

Thx,
D. Received on Thu Oct 11 2001 - 21:51:38 CDT