removing time element from date on sqlload

[Horace]

I've been messing about with this for half an hour now.

I'm loading from a csv file into a table with a date column, (DATE_OF_BIRTH DATE)

Input data is e.g. 23/12/1964 00:00

Getting error "Field in data file exceeds maximum length"

How do I remove the timestamp on load??

Been looking at

REPLACE INTO TABLE temp
(
.......
DATE_OF_BIRTH date(10) "DD/MM/YYYY"
.......
)

but that doesn't seem to work

[simply_dba]

to_date('23/12/1964 00:00','dd/mm/yyyy')

[DaPi]

to_date('23/12/1964 00:00','dd/mm/yyyy hh24:mi') might work better!

the ref is: http://www.csee.umbc.edu/help/oracle.../ch05.htm#6132

[Horace]

How does that remove the time element Dapi?

[DaPi]

Ah!

1) A date field always has a time part, so you can't get rid of it. I had assumed that all your times were 00:00 as in the example.

2) Try: myfield DATE "to_date(substr(:myfield,1,10),'dd/mm/yyyy')"