[jira] [Created] (FLINK-21714) Use TIMESTAMP_LTZ as return type for function PROCTIME()

[Shang Yuanchun (Jira)]

Leonard Xu created FLINK-21714:
----------------------------------

             Summary: Use TIMESTAMP_LTZ as return type for function PROCTIME()
                 Key: FLINK-21714
                 URL: https://issues.apache.org/jira/browse/FLINK-21714
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / API
            Reporter: Leonard Xu


When users use a PROCTIME() in SQL, the return value of PROCTIME() has a timezone offset with the wall-clock time in users' local time zone, users need to add their local time zone offset manually to get expected local timestamp(e.g: Users in Germany need to +1h to get expected local timestamp). 

This issue to correct PROCTIME()  function
|*function*|*existed problem*|*current behavior*|*proposed changes*|
|PROCTIME()|returns UTC timestamp, but user expects current timestamp in session time zone|return type: TIMESTAMP  *PROCTIME*
#session timezone: UTC
2020-12-28 23:52:52
#session timezone: UTC+8
2020-12-28 23:52:52|return current timestamp in session time zone for PROCTIME(), the return type should be *TIMESTAMP  WITH LOCAL TIME ZONE *PROCTIME**
#session timezone: UTC
2020-12-28 23:52:52
#session timezone: UTC+8
2020-12-29 07:52:52|



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