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 |
------------------ ???????? ------------------ ??????: "xuzh" <huazhe...@foxmail.com>; ????????: 2020??9??9??(??????) ????3:06 ??????: "user-zh"<user-zh@flink.apache.org>; ????: localtimestamp??current_timestamp????mysql???????? Dear all?? ???? > CREATE TABLE sink ( > id INT, > prod_nm STRING, > dtm timestamp, > primary key(id) NOT ENFORCED -- '??????????????' > ) > WITH ( > 'connector' = 'jdbc', > 'url' = 'jdbc:mysql://10.0.0.0:3306/rs_report?useUnicode=true&characterEncoding=UTF-8', > 'table-name' = 'sink', > 'driver' = 'com.mysql.jdbc.Driver', > 'username' = 'dps', > 'password' = 'dps' > ); insert into sink select id,prod_nm,current_timestamp from product; ????????mysql ??dtm???????????? ??????????????????????8??????????????????????????21???? insert into sink select id,prod_nm,localtimestamp from product; ????????mysql ??dtm???????????????? ??????????????????????????????????????8????.