Re: Loading A Date With SQLLoader

Greg Teets wrote:

> 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 ","
>
 

> (TRANS_DATE DATE "MM/DD/YYYY",
 
> 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.

[Quoted] That should do it.

Harry Received on Tue Sep 12 2000 - 19:02:39 CEST