Re: sqlldr & date/time question

"KTyson9426" <ktyson9426_at_aol.com> wrote in message news:20020309173408.19833.00000557_at_mb-cc.aol.com...
> Hello.... And thank you in adnvace for anyones help
>
> I want to use sqlldr to load the date/time into the same date field in my
> table. I can get the date in there ok, and I can get the time in with the
use
> of a different field, but I can't find anything that tells me how to do
get the
> date/time in the same field. I've found how to do this with an 'insert'
> statement, but I need to use sqlldr..... Can anyone tell me how to
format the
> *.ctl file? Currently I have;
>
> load data
> infile *
> append into table vmstat
> fields terminated by ","
> (ddate, ttime, vmstat)
> begindata
> 30-Jan-02, 0122, 'data'

Hi,

try this:

load data
infile *
append into table vmstat
fields terminated by ","
(ddate position(1:15) date "dd-mon-rr, hh24mi", ttime, vmstat) begindata
30-Jan-02, 0122, 'data'

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com