Re: SQL*LOADER: How to read in TIME fields?

From: Nicolas Issakides <nissakid_at_planete.net>
Date: 1998/03/19
Message-ID: <35115ea6.0@Kampot.pci>#1/1

not 100% sure about the solution but try to use HH24:MI:ss for the time format

select to_char (sysdate,'HH:MM:SS') from dual

will return

TO_CHAR(

---

07:03:09

(in fact, it is now 19:03)

but
select to_char (sysdate,'hh24:mi:SS') from dual

TO_CHAR(

---

19:04:57

this kind of differences make that sqlloader will try to use 0-12 range for hours instead of 0-23

In article <6ep5r3$i3e$1_at_psun6.dsccc.com>, jstrange_at_imtn.dsccc.com (John Strange) wrote:
>You might try TIME instead of DATE
>
>
>Andreas Seebeck (A.Seebeck_at_t-online.de) 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
 

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

>: Any suggestions?
 

>: Thanks in advance,
>: Andreas Seebeck
>

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Thu Mar 19 1998 - 00:00:00 CST