Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.cc.ukans.edu!logbridge.uoregon.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: sql loader time field only no date Date: Wed, 05 May 2004 09:08:37 -0700 Organization: ATS Message-ID: <1083773316.247622@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 41 Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:85573 Noel wrote: >>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 And is there an explanation for the 'interesting' usage of mixed isngle and double quotes? -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)