Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.moat.net!nntp.idg.pl!newsfeed.gazeta.pl!news.gazeta.pl!not-for-mail
From: "Noel" <tomekb@softman.pl>
Newsgroups: comp.databases.oracle.tools
Subject: Re: sql loader time field only no date
Date: Wed, 5 May 2004 10:47:29 +0200
Organization: Portal Gazeta.pl -> http://www.gazeta.pl
Lines: 31
Message-ID: <c7a9mo$708$1@inews.gazeta.pl>
References: <b04bbca4.0404291107.3d0fc476@posting.google.com>
NNTP-Posting-Host: 62.148.92.194
X-Trace: inews.gazeta.pl 1083746840 7176 62.148.92.194 (5 May 2004 08:47:20 GMT)
X-Complaints-To: usenet@agora.pl
NNTP-Posting-Date: Wed, 5 May 2004 08:47:20 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Priority: 3
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-User: tbal
X-MSMail-Priority: Normal
Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:85572


> Thanks in advance.
> I have the following comma seperate fields:
> dlls001,0x000123456,545678,GMT-4:00-Eastern-DST,04/16/2004,10:18:22.4
> I am stuck with the following control file:
> LOAD DATE
> APPEND INTO TABLE ATTEMPT_REC
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
> (
>     node      char,
>     gateway   char,
>     accId     char,
>     timeZone  char,
>     starDate  date "MM/DD/YYYY",
>     startTime timestamp "hh:mm:ss:d"
> )
> the error is Rejected - Error on table ATTEMPT_REC, column STARTTIME
> ORA-01843: not a valid month

Hi.
I give you a clue:

select to_date('10:18:22.4','hh:mm:ss:d') from dual;
select to_date('10:18:22.4','hh:mi:ss"."dd') from dual;

And please read error message carefully... (mm is month not minutes).
--
TomekB