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 -> SQL*LOADER: How to read in TIME fields?

SQL*LOADER: How to read in TIME fields?

From: Andreas Seebeck <A.Seebeck_at_t-online.de>
Date: 1998/03/18
Message-ID: <6eo1md$fj8$1@news00.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

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

Any suggestions?

Thanks in advance,
Andreas Seebeck Received on Wed Mar 18 1998 - 00:00:00 CST

Original text of this message

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