| date format [message #368137] |
Fri, 01 September 2000 08:02  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
