Home » RDBMS Server » Server Utilities » date format
date format [message #368137] Fri, 01 September 2000 08:02 Go to next message
melle
Messages: 2
Registered: September 2000
Junior Member
hi

I having trouble parsing a csv file into Oracle with sqlloader.

the following is my control file

LOAD DATA
INFILE 'C:\tmp\accesssoll.csv'
INTO TABLE sollsollicitanten
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"'
(
soll_id,
hk_herkomst,
func_functie,
soll_emailadres,
soll_voornaam,
soll_achternaam,
soll_geboortedatum "to_date(:soll_geboortedatum,'DD-MM-YYYY hh:mm:ss')",
soll_woonplaats,
soll_datum_1st_contact "to_date(:soll_datum_1st_contact,'DD-MM-YYYY hh:mm:ss')",
soll_einddatum "to_date(:soll_einddatum,'DD-MM-YYYY hh:mm:ss')",
loc_locatie,
stat_status
)

And this is a example of the record I want to parse:

10;"Internet";"Onbekend";"?????@??????.nl";"J.";"Hennekes";19-5-1956 0:00:00;"Amsterdam";8-10-2000 0:00:00;;"Amsterdam";"Ontvangen"

You can see that date is followed with a timestamp and that I try to get this in the control file.

The problem has to do with the date because the only records which are succesfully parsed to to the table are those records in which there is no date attribute.

hope you can help

regards melle
Re: date format [message #368138 is a reply to message #368137] Fri, 01 September 2000 08:58 Go to previous message
Paulette
Messages: 1
Registered: September 2000
Junior Member
Melle,

One other note: In your time format 'hh:mm:ss' -- the mm should be mi for
minutes (you may also want to uppercase this whole string). This could also be
the problem.

Good luck.

Paulette Aye
Previous Topic: date format
Next Topic: IMP/EXP utility
Goto Forum:
  


Current Time: Sat May 21 04:49:39 CDT 2022