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
|
|
|