[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

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