Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLLoader not able to read time?

SQLLoader not able to read time?

From: Andreas Seebeck <A.Seebeck_at_t-online.de>
Date: 1998/03/20
Message-ID: <6etfn6$peu$1@news01.btx.dtag.de>#1/1

Hi,

does anybody know how I can read time fields with sqlloader? In the ascii file they are written like 21:30:00. In the control file I tried it with CHAR, DATE and DATE "hh-mm-ss" and DATE "hh:mm:ss", but nothing works.
SQLLoader gives this message:

Record 1: Rejected - Error on table KUNDEN_LEISTUNG. OCA-30021: error preparing/executing SQL statement [POL-2416] invalid date/time format

TIME doesn't work, too, it's even not a keyword of SQLLoader.

The database is Personal Oracle Lite, and the field type is TIME.

Any suggestions?

Thanks in advance,
Andreas Seebeck Received on Fri Mar 20 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US