Home » RDBMS Server » Server Utilities » date format
date format [message #368136] Fri, 01 September 2000 08:00
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
Previous Topic: Oracle to MS Access
Next Topic: date format
Goto Forum:
  


Current Time: Thu Mar 28 15:18:21 CDT 2024