Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problems with SQL Loader Timestamp

Problems with SQL Loader Timestamp

From: Celia <member37093_at_dbforums.com>
Date: Wed, 27 Aug 2003 06:26:05 -0400
Message-ID: <3290228.1061979965@dbforums.com>

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
Received on Wed Aug 27 2003 - 05:26:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US