Loading A Date With SQLLoader
From: Greg Teets <gteets_at_rr.cinci.com>
Date: Tue, 12 Sep 2000 16:29:37 GMT
Message-ID: <39be6725.35046263_at_news-server>
Date: Tue, 12 Sep 2000 16:29:37 GMT
Message-ID: <39be6725.35046263_at_news-server>
[Quoted] [Quoted] I have a comma-separated file that I am loading with SQLLoader. How do I convert a date to the right format. I'm pretty sure i use to_date but i don't know the correct syntax within SQLLoader.
Here is my control file. It works fine except that i get a message that there is a bad month in the date.
LOAD DATA
INFILE 'd:\greg\transactions.dat'
BADFILE 'd:\greg\transactions.bad'
INSERT
INTO TABLE TRANSACTION
FIELDS TERMINATED BY ","
[Quoted] (TRANS_DATE, TRANS, QUANTITY, SYMBOL, PRICE, COMMISSION, FEES,
TRANS_TOTAL, TRANS_ID)
Here is my data file:
09/08/2000,2,3000.00,CNC,8.875,30.00,0.89,26594.11,8
Thanks in advance.
Received on Tue Sep 12 2000 - 18:29:37 CEST