1??timestamp????????????????????????????????????varchar?? 2?????????????????????????????? ????????????2020-09-09 15:25:55.416 ???????????? local_dtm | curr_dtm | local_dtm_no_zone | curr_dtm_no_zone | ------------------------ | ------------------------ | ------------------------ | ------------------------ | 2020-09-09 02:25:55.416 | 2020-09-08 18:25:55.416 | 2020-09-09 02:25:55.416 | 2020-09-08 18:25:55.416 |
CREATE TABLE `sink2` ( `local_dtm` varchar(100) DEFAULT NULL, `curr_dtm` varchar(100) DEFAULT NULL, `local_dtm_no_zone` varchar(100) DEFAULT NULL, `curr_dtm_no_zone` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 drop table if exists sk; CREATE TABLE sk ( local_dtm TIMESTAMP, curr_dtm TIMESTAMP, local_dtm_no_zone TIMESTAMP WITHOUT TIME ZONE, curr_dtm_no_zone TIMESTAMP WITHOUT TIME ZONE ) WITH ( 'connector' = 'jdbc', 'url' = 'jdbc:mysql://10.12.5.37:3306/rs_report?useUnicode=true&amp;characterEncoding=UTF-8', 'table-name' = 'sink2', 'driver' = 'com.mysql.jdbc.Driver', 'username' = 'dps', 'password' = 'dps1234' ); insert into sk values(localtimestamp,current_timestamp,localtimestamp ,current_timestamp); ????????????2020-09-09 15:25:55.416 ???????????? local_dtm | curr_dtm | local_dtm_no_zone | curr_dtm_no_zone | ------------------------ | ------------------------ | ------------------------ | ------------------------ | 2020-09-09 02:25:55.416 | 2020-09-08 18:25:55.416 | 2020-09-09 02:25:55.416 | 2020-09-08 18:25:55.416 | ------------------ ???????? ------------------ ??????: "xuzh" <443435...@qq.com>; ????????: 2020??9??10??(??????) ????10:01 ??????: "xbjtdcq"<xbjt...@gmail.com>;"user-zh"<user-zh@flink.apache.org>; ????: Re:Re: localtimestamp??current_timestamp????mysql???????? 1??timestamp????????????????????????????????????varchar?? 2??????????????????????????????