[FLINK-19433] An Error example of FROM_UNIXTIME function in document

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.3, 1.12.0
• Component/s: Documentation, Table SQL / API
• Labels: pull-request-available
• Assignee: Kyle Zhang
• Reporter: Kyle Zhang
• Created: 27/Sep/20 09:01
• Updated: 19/Feb/21 07:30
• Resolved: 29/Sep/20 03:26

Description

In the documentation:https://ci.apache.org/projects/flink/flink-docs-release-1.11/dev/table/functions/systemFunctions.html#temporal-functions

There is an example in FROM_UNIXTIME function

E.g., FROM_UNIXTIME(44) returns '1970-01-01 09:00:44' if in UTC time zone, but returns '1970-01-01 09:00:44' if in 'Asia/Tokyo' time zone.

However, the correct result should be 1970-01-01 00:00:44 in UTC time zone

 

Issue Links

• duplicates: FLINK-20101 Fix the wrong documentation of FROM_UNIXTIME function
• links to: GitHub Pull Request #13493