[jira] [Created] (FLINK-9948) JSON format does not convert timestamps correctly

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-9948) JSON format does not convert timestamps correctly

Shang Yuanchun (Jira)
Timo Walther created FLINK-9948:
-----------------------------------

             Summary: JSON format does not convert timestamps correctly
                 Key: FLINK-9948
                 URL: https://issues.apache.org/jira/browse/FLINK-9948
             Project: Flink
          Issue Type: Bug
          Components: Table API & SQL
            Reporter: Timo Walther


Currently, the JSON format supports timestamps in the UTC timezone {{"1990-10-14T12:12:43Z"}}. However, the conversion in the current implementation is not correct since timestamps in SQL do not contain a timezone and depend on the local timezone of the JVM. Casting a rowtime into a string results in an undesired offset at the moment. Fixing this problem might depend on the bigger issue of proper timezone support.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)