Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I set the quote character to '' in the file connection, but the timestamp type is not added. How can I force the quote character to be added to all field values。
eg:
"20211007033118000000000000000001005","D",,"00000ddc.023e6c22.00000001.0064.01.0000:2447.40793.16","DELETE","0A004700000000000000000000000000",2021-10-07 03:31:18.000000,10114110000242026058,"1","10124110000001001755","411023070060156","411023197503152692","411092","03","0190",2021-10-07 11:31:13.000000
the last column data type is timestamp
can you share some sample data
the source database is ORACLE
the create table scrpit:
create table test
(
djxh NUMBER(20) not null,
lrr_dm CHAR(11) not null,
lrrq DATE not null,
xgr_dm CHAR(11),
xgrq DATE,
sjgsdq CHAR(11) not null,
tb_sj TIMESTAMP(6)
);
the data sql scripts:
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.01141100002443E19, '14110815032', to_date('03-12-2012', 'dd-mm-yyyy'), '141gdgghhyg', to_date('28-04-2017 17:34:27', 'dd-mm-yyyy hh24:mi:ss'), '14110818400', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.01141100002443E19, '14110826003', to_date('01-08-2014 10:32:03', 'dd-mm-yyyy hh24:mi:ss'), '24110820701', to_date('26-12-2019 11:05:32', 'dd-mm-yyyy hh24:mi:ss'), '14110827200', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.01141100002449E19, '14100000000', to_date('03-01-2015 12:22:12', 'dd-mm-yyyy hh24:mi:ss'), '00000000000', to_date('02-09-2019 19:02:02', 'dd-mm-yyyy hh24:mi:ss'), '14110009400', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.01141100002449E19, '14100000000', to_date('03-01-2015 12:22:12', 'dd-mm-yyyy hh24:mi:ss'), '00000000000', to_date('02-09-2019 19:02:02', 'dd-mm-yyyy hh24:mi:ss'), '14110009400', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.01141100002449E19, '14100000000', to_date('03-01-2015 12:22:12', 'dd-mm-yyyy hh24:mi:ss'), '00000000000', to_date('02-09-2019 19:02:12', 'dd-mm-yyyy hh24:mi:ss'), '14110810000', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.02141100000013E19, '24110020063', to_date('21-03-2019 09:32:08', 'dd-mm-yyyy hh24:mi:ss'), '00000000000', to_date('02-09-2019 19:02:12', 'dd-mm-yyyy hh24:mi:ss'), '14110927300', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.02141100000013E19, '14110246606', to_date('21-03-2019 09:14:59', 'dd-mm-yyyy hh24:mi:ss'), '14110245103', to_date('24-07-2020 08:48:57', 'dd-mm-yyyy hh24:mi:ss'), '14110247700', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.02141100000013E19, '14110811703', to_date('21-03-2019 09:15:49', 'dd-mm-yyyy hh24:mi:ss'), '14110815702', to_date('01-04-2019 15:42:22', 'dd-mm-yyyy hh24:mi:ss'), '14110817700', '06-APR-21 02.43.04.000000 PM');
insert into hx_dj.test (DJXH, LRR_DM, LRRQ, XGR_DM, XGRQ, SJGSDQ, TB_SJ)
values (1.01141100002415E19, '14110814202', to_date('11-10-2011', 'dd-mm-yyyy'), '14110815913', to_date('28-08-2019 09:26:24', 'dd-mm-yyyy hh24:mi:ss'), '14110818500', '06-APR-21 02.43.04.000000 PM');
commit;
the file connection setting: