[FLINK-17752] Align the timestamp format with Flink SQL types in JSON format

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Component/s: Formats (JSON, Avro, Parquet, ORC, SequenceFile), Table SQL / Ecosystem
• Assignee: Shengkai Fang
• Reporter: Jark Wu
• Created: 16/May/20 09:23
• Updated: 23/Mar/21 10:00
• Resolved: 10/Nov/20 02:11

Description

Currently, we are using RFC3339_TIMESTAMP_FORMAT (which will add timezone at the end of string) to as the timestamp format in JSON. However, the string representation fo TIMESTAMP (WITHOUT TIME ZONE) shoudn't adding 'Z' at the end.

Other discussions:
[1]: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/TIME-TIMESTAMP-parse-in-Flink-TABLE-SQL-API-td33061.html
[2]: http://apache-flink.147419.n8.nabble.com/json-timestamp-json-flink-sql-td1914.html
[3]: http://apache-flink.147419.n8.nabble.com/FLINK-SQL-td2074.html

Issue Links

• duplicates: FLINK-16725 Support to parse various timestamp data format in JSON

Sub-Tasks

• Add support for datetype TIMESTAMP_WITH_LOCAL_ZONE for Json format: Closed
• Add option in json format to parse timestamp in different standard: Closed