Problems with SQL Loader Timestamp

Hi,

there`s a problem with the data type date in SQL Loader. I'm trying to load a file with the following format:

2003-02-12 10:28:13.0, field2, ...

I'd like to load the first field like a date not like a timestamp, but SQL Loader always gives me the same error: "ORA-01821: date format not recognized"

I don't know what else I can do. I've tried tu put:

FECHA DATE to_date(substr(:CMJE_FX_ENTRADA,1,19)

,'yyyy-mm-dd hh24:mi:ss')" terminated by '.', dummy FILLER

but it doesn't work either. I don't mind at all if my field finally is a date or a timestamp, the only I want is SQL Loader could read it.

Thanks

--
CMP


Posted via http://dbforums.com