Re: Sql Loader and dates.

From: <michael_bialik_at_my-deja.com>
Date: Fri, 23 Jul 1999 20:51:56 GMT
Message-ID: <7nakl9$uvg$1@nnrp1.deja.com>

Hi.

I think you have twice MM ( once for month and second time for minutes ).

Try "DD-MM-YYYY HH:MI" instead.

Good luck. Michael.

In article <3796CBD4.C78531AE_at_integral-solutions.fr>, Ludovic MARLATS <marlats_at_integral-solutions.fr> wrote:
> I have to load files into tables. This files are text files and
includes
> date fields.
> In text files date appears like this :
>
> 16-04-1997 00:00
>
> In the control file (CTL), there is :
>
> VEIDTTARGA DATE(16) "jj-mm-aaaa hh:mm" nullif
> VEIDTTARGA=blanks
>
> But when I start SQLLDR, log file includes the following Error :
>
> Record 1: Rejected - Error on table [name table], column
VEIDTTARGA.
>
> ORA-01810: format code appears twice
> ...
>
> What's wrong with my date format ?
>
> Thanks.
>
> --
>
> Ludovic MARLATS
> marlats_at_integral-solutions.fr
>
> -----------------------
>
> Integral Solutions
> Parc Cadéra
> 33700 MERIGNAC
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 23 1999 - 15:51:56 CDT