Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with SQLLoader Date columns and JDBC access
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 SonyReceived on Thu Jul 20 2006 - 04:23:14 CDT