Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql loader time field only no date

sql loader time field only no date

From: Bob <rgants_at_speakeasy.net>
Date: 30 Apr 2004 08:05:06 -0700
Message-ID: <b04bbca4.0404300705.5cd82a0e@posting.google.com>


Thanks in advance.

I have the following comma seperate fields:

dlls001,0x000123456,545678,GMT-4:00-Eastern-DST,04/16/2004,10:18:22.4

the problem is with the last field. I need to treat this as a seperate TIME ONLY field. I can not figure out how to account for this in a sql loader control file. I keep failing because the sql loader wants a date part.

I am stuck with the following control file:

LOAD DATE
APPEND INTO TABLE ATTEMPT_REC
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (

    node      char,
    gateway   char,
    accId     char,
    timeZone  char,

    starDate date "MM/DD/YYYY",
    startTime timestamp "hh:mm:ss:d"
)

the error is Rejected - Error on table ATTEMPT_REC, column STARTTIME ORA-01843: not a valid month Received on Fri Apr 30 2004 - 10:05:06 CDT

Original text of this message

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