Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Loader and dates.
format code for month is mm and for minute it is mi
try changing minute format code from mm to mi
Ludovic MARLATS <marlats_at_integral-solutions.fr> wrote in message
news:3796CBD4.C78531AE_at_integral-solutions.fr...
> 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
>
>
Received on Thu Jul 22 1999 - 16:33:53 CDT