Couple of methods,
1. Use Position instead of delimited control file
specification and use SQL to massage to the ata
For eaxmple
my_date position(1:19)
substr(:mydate,1,10)||substr(:mydate,11)
Of course you can do this directly as
METHOD 2:
my_date position(1:10) filler,
my_time
Hi DBAs,
I am trying to combine 2 fields into 1 field to insert into a date field
using sql loader.
The csv files has the first 2 fields as follows
01/01/2002,00:00:01,...,
Can someone help on how to combine the 1st two fields to insert into a
single date field.
Thanks
Rick
--
Please see
[EMAIL PROTECTED] wrote:
Hi DBAs,
I am trying to combine 2 fields into 1 field to insert into a date field
using sql loader.
The csv files has the first 2 fields as follows
01/01/2002,00:00:01,...,
Can someone help on how to combine the 1st two fields to insert into a
single date