[jira] [Created] (FLINK-20162) Fix time zone problems of some time related functions

[Shang Yuanchun (Jira)]

Jark Wu created FLINK-20162:
-------------------------------

             Summary: Fix time zone problems of some time related functions
                 Key: FLINK-20162
                 URL: https://issues.apache.org/jira/browse/FLINK-20162
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API
            Reporter: Jark Wu
             Fix For: 1.13.0


Currently, lots of time related functions are returning {{TIMESTAMP}} type, including {{PROCTIME()}}, {{NOW()}}, {{LOCALTIMESTAMP}},etc. However, they should return {{TIMESTAMP WIHT LOCAL TIME ZONE}} type. The session time zone will be used when converting {{TIMESTAMP WITH LOCAL TIME ZONE}} to string, but not for {{TIMESTAMP}} type.

That's why many users report the result is incorrect with 8 hours when converting these functions to string.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)