SQL Loader field concat

[TomazZ]

Hi all,

I have table with a date column.
In input file I get date and time in separate fields like this:
aba;123123;19.11.02;15:48:33;

If terminated by ';', how can I put date (3rd col) and time (4th col)
in one date column in table?

Thanks,
Tomaz

[TomazZ]

Got it ))

FIELDS TERMINATED BY ';'
(a, b,
dat boundfiller char,
datetime date 'dd.mm.rr hh24:mi:ss' ":dat||' '||:datetime")

have a nice time...