Re: Problems with SQL Loader Timestamp

From: Micky <michael.volk_at_bertelsmann.de>
Date: 29 Aug 2003 03:59:28 -0700
Message-ID: <d58a08b5.0308290259.5370eb26@posting.google.com>

Hi, I just had a similar problem, which I resolved by something like this:

Try this one:

FIELD1 "to_date(substr(:FIELD1, 1, instr(:FIELD1, '.', 1, 1) - 1),'YYYY-MM-DD HH24:MI:SS')"
where FIELD1 is the name of your column

Reason: I think that Oracle cannot insert 2003-02-12 10:28:13.0 but only
2003-02-12 10:28:13
because Oracle uses only seconds for date format (and not milliseconds)

Remark: Do not write FIELD1 date "to_date(......

but FIELD1 "to_date(.....

Hope it helps Received on Fri Aug 29 2003 - 05:59:28 CDT