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

Home -> Community -> Usenet -> c.d.o.server -> Re: Formatting time fields in SQL*Loader

Re: Formatting time fields in SQL*Loader

From: Palani <Palani_at_adv-info.com.sg>
Date: Wed, 9 Feb 2000 11:18:41 +0800
Message-ID: <87qm87$eqj$1@newton3.pacific.net.sg>


hi
i cant understand your problem more specifically. Any way if you want to load date field in to the table thro' sqlloader, querry the date field with to_date option. i.e.,
SELECT a,TO_DATE(b),
FROM XXXX;
Now if you load into the table, the b field will be date datatype. make sure the table is empty before loading ---palani

"News" <lesley_at_vimich.com> wrote in message news:87q1e801163_at_enews3.newsguy.com...
> Hello everyone. I'm just learning Oracle and SQL*Loader and I'm in the
> middle of an import from dataease into Oracle 8i. I can't seem to find
> anything in the documentation about formatting time in my control file for
> SQL*Loader? Can I use DATE? If not, can I format time?
> Any suggestions are appreciated!
> Lesley
>
>
>
>
Received on Tue Feb 08 2000 - 21:18:41 CST

Original text of this message

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