Re: SQLLoader not able to read time?

From: Robert Prendin <rprendin_at_magi.com>
Date: 1998/03/21
Message-ID: <35142d7b.1395956058@news.istar.ca>#1/1

I just tested this and it seems to work OK..... I stored it in a date field but defined the date format mask in the control file..
Here's the control file...

	load data
	infile lt.ctl
	into table 
	test2 (t1 date 'hh24:mi:ss')

The text file contained only one record and looked like this
	21:20:22

Here's the data in the table after the load SQL> select * from test2;

no rows selected

SQL> / T1

---

01-MAR-98 SQL> select to_char(t1,'hh24:mi:ss') from test2;

TO_CHAR(

---

21:20:22

SQL> The date seems to have defaulted to the 1st day of the current month.. but the time is ok....

Any problems, just send an e-mail or contact me at 613-761-0314
 Cheers, Robert, Prendin
Ottawa, Canada

A.Seebeck_at_t-online.de (Andreas Seebeck) wrote:

>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 Sat Mar 21 1998 - 00:00:00 CST