[ https://issues.apache.org/jira/browse/FLINK-27018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17524799#comment-17524799 ]
Yao Zhang commented on FLINK-27018: ----------------------------------- Hi [~jeff-zou] , We cannot simple use `LocalDateTime.toString()` as in current implemetattion Flink json format should support datetime with both ISO-8601 and SQL standard. It seems that ISO-8601 does not explicitly stipulate the precision of milliseconds or nanoseconds. But personally I agree that the time format should be consistent. See [JSON | Apache Flink|https://nightlies.apache.org/flink/flink-docs-release-1.14/zh/docs/connectors/table/formats/json/] > timestamp missing end zero when outputing to kafka > --------------------------------------------------- > > Key: FLINK-27018 > URL: https://issues.apache.org/jira/browse/FLINK-27018 > Project: Flink > Issue Type: Bug > Components: Connectors / Kafka > Affects Versions: 1.13.5 > Reporter: jeff-zou > Priority: Major > Attachments: kafka.png > > > the bug is described as follows: > > {code:java} > data in source: > 2022-04-02 03:34:21.260 > but after sink by sql, data in kafka: > 2022-04-02 03:34:21.26 > {code} > > data miss end zero in kafka. > > sql: > {code:java} > create kafka_table(stime stimestamp) with ('connector'='kafka','format' = > 'json'); > insert into kafka_table select stime from (values(timestamp '2022-04-02 > 03:34:21.260')){code} > the value in kafka is : \{"stime":"2022-04-02 03:34:21.26"}, missed end zero. -- This message was sent by Atlassian Jira (v8.20.7#820007)