Re: Loading A Date With SQLLoader

Thanks.

On Tue, 12 Sep 2000 13:02:39 -0400, Harry Joe <hvattyam_at_yahoo.com> wrote:

>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.
>
>That should do it.
>
>Harry
>
>
>
Received on Wed Sep 13 2000 - 02:35:55 CEST