Re: DATE in SQL Loader

On Sun, 27 Jul 1997 22:18:23 +0000, Chrysalis <cellis_at_iol.ie> wrote:

A typo indeed!

Thanks.

>greg teets wrote:
>>
>> I'm trying to load some date with SQLLoader that do not have a zero
>> when the month or day is less than ten. I am currently using the
>> following line in my .ctl file:
>>
>> QUOTE_DATE_DATE DATE "FXFMMM/MM/YY",
>>
>> I got this syntax from the section on Format Models in the manual.
>> However, I got the error:
>>
>> ORA-01810: format code appears twice
>>
>> when I ran Loader.
>>
>> Am I on the right track? If not, please explain how to load records
>> which drop the zero in this situation.
>>
>> Thanks in advance.
>>
>> Greg
>
>It looks as if you have a typo in your string, which contains
>"...MM/MM/YY", and does indeed have a duplicate format code.
>
>I assume you intended "fxfmDD/MM/YY", but I'm not convinced you need the
>"fx" modifier as well as the "fm". (Note that the "fm" applies to *all*
>subsequent elements of the format string)
>
>HTH
>
>--
>Chrysalis
>
>FABRICATI DIEM, PVNC
>('To Protect and to Serve')
>Terry Pratchett : "Guards Guards"
Received on Sun Jul 27 1997 - 00:00:00 CEST