[FLINK-21617] FLIP-162: Consistent Flink SQL time function behavior

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.13.0
• Component/s: Table SQL / API
• Assignee: Leonard Xu
• Reporter: Leonard Xu
• Created: 05/Mar/21 03:59
• Updated: 13/Oct/22 19:04
• Resolved: 23/Apr/21 09:56

Description

https://cwiki.apache.org/confluence/display/FLINK/FLIP-162%3A+Consistent+Flink+SQL+time+function+behavior

Issue Links

• is related to: FLINK-20162 Fix time zone problems for some time related functions
• is related to: FLINK-16889 Support converting BIGINT to TIMESTAMP for TO_TIMESTAMP function
• relates to: FLINK-11223 Time zone problem for time processing function
• relates to: FLINK-8353 Add support for timezones
• relates to: FLINK-21803 Tumbling / Sliding windows are unaware of daylight savings time
• mentioned in: Page Loading...

Sub-Tasks

• Support abbreviation TIMESTAMP_LTZ FOR TIMESTAMP WITH LOCAL TIME ZONE: Closed
• Support TIMESTAMP_LTZ arithmetic: Closed
• Introduce function TO_TIMESTAMP_LTZ(numeric [, precision]): Closed
• Disable problematic cast conversion between NUMERIC type and TIMESTAMP type: Closed
• Correct FLOOR/CEIL (TIMESTAMP/TIMESTAMP_LTZ/DATE TO WEEK) functions: Closed
• Correct function CURRENT_TIMESTAMP/CURRENT_TIME/CURRENT_DATE/NOW/LOCALTIME/LOCALTIMESTAMP: Closed
• Introduce CURRENT_ROW_TIMESTAMP() function: Closed
• Use TIMESTAMP_LTZ as return type for function PROCTIME(): Closed
• Support defining event time attribute on TIMESTAMP_LTZ column: Closed
• Support implicit cast conversion between timestamp and timestamp_ltz: Closed
• Support TIMESTAMP_LTZ type in CSV format: Closed
• Disable cast conversion between Numeric type and TIMESTAMP_LTZ type: Closed
• Change precision argument from optional to required in TO_TIMESTAMP_LTZ(numeric, precision): Closed
• Add docs for consistent time functions and compatibility specification: Closed
• Manual test time function changes and new time attributes support: Closed