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 -> Re: Problem with SQLLoader Date columns and JDBC access

Re: Problem with SQLLoader Date columns and JDBC access

From: Thomas Kellerer <BDHLDUUTPRWS_at_spammotel.com>
Date: Thu, 20 Jul 2006 11:23:14 +0200
Message-ID: <4i90c1F2n53mU1@individual.net>


On 19.07.2006 15:36 Mark D Powell wrote:
> If the table column is defined as a date but the character represtation
> of the date is a timestamp truncate off the fractional seconds using a
> substr function. From my notes where I did something like this:
>
> FLD2 NEXT * , O(") CHARACTER
> SQL string for column :
> "to_date(substr(:fld2,1,19),'YYYY.MM.DD.HH24.MI.SS')
>
> Worked for me.

For me too ;)
I never tried to use to_date() I always declared the column as DATE and then tried the substr() thing. Bu this works fine.

Thanks a lot!

Thomas

-- 
It's not a RootKit - it's a Sony
Received on Thu Jul 20 2006 - 04:23:14 CDT

Original text of this message

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