[FLINK-8353] Add support for timezones

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: Timo Walther
• Created: 03/Jan/18 11:08
• Updated: 30/Apr/21 02:34
• Resolved: 30/Apr/21 02:34

Description

This is an umbrella issue for adding support for timezones in the Table & SQL API.

Usually companies work with different timezones simultaneously. We could add support for the new time classes introduced with Java 8 and enable our scalar functions to also work with those (or some custom time class implementations like those from Calcite). We need a good design for this to address most of the problems users face related to timestamp and timezones.

It is up for discussion how to ship date, time, timestamp instances through the cluster.

Issue Links

• is related to: FLINK-21617 FLIP-162: Consistent Flink SQL time function behavior
• is related to: FLINK-8094 Support other types for ExistingField rowtime extractor
• relates to: FLINK-10032 Rework SQL DATE_FORMAT function
• relates to: FLINK-7735 Improve date/time handling in publically-facing Expressions

Sub-Tasks

• JSON format does not convert timestamps correctly: Open