[jira] [Created] (FLINK-8169) Document timestamp and timezone behavior for Table API & SQL

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

[jira] [Created] (FLINK-8169) Document timestamp and timezone behavior for Table API & SQL

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

             Summary: Document timestamp and timezone behavior for Table API & SQL
                 Key: FLINK-8169
                 URL: https://issues.apache.org/jira/browse/FLINK-8169
             Project: Flink
          Issue Type: Improvement
          Components: Table API & SQL
            Reporter: Timo Walther


{{java.sql.Date}}, {{java.sql.Time}}, and {{java.sql.Timestamp}} are timezone dependent. However, in Flink's Table & SQL API we remove this dependency and work with UTC timestamps internally. It should be documented how windows use the timestamps in different timezones for event-time. The behavior for processing-time should be explained as well. What is the result if I cast both timestamps to Long, String, or output them to a DataSet/DataStream?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)