Re: Sql Loader and dates.

From: Sally Pearce <nospam_at_dundee.ncr/com>
Date: Thu, 22 Jul 1999 15:20:32 +0100
Message-ID: <37971a3c@rpc1284.daytonoh.ncr.com>

The format should be "jj-mm-aaaa hh:mi"

mm=months mi=minutes

> 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 ?
>
Received on Thu Jul 22 1999 - 09:20:32 CDT

This message: [ Message body ]
Next message: johnsullivan_at_my-deja.com: "8.1.5 automatic exports on NT"
Previous message: Michel Lee: "MTS HPUX10.20 ORACLE7.3.4 works?mlml"
In reply to: Ludovic MARLATS: "Sql Loader and dates."
Next in thread: Manish Shah: "Re: Sql Loader and dates."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US