Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.comReceived on Wed Aug 27 2003 - 05:26:05 CDT
![]() |
![]() |