Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-20162

Fix time zone problems for some time related functions

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • None
    • Table SQL / API

    Description

      Currently, lots of time related functions are returning TIMESTAMP type, including PROCTIME(), NOW(), LOCALTIMESTAMP,etc. However, they should return TIMESTAMP WIHT LOCAL TIME ZONE type. The session time zone will be used when converting TIMESTAMP WITH LOCAL TIME ZONE to string, but not for TIMESTAMP type.

      That's why many users report the result is incorrect with 8 hours when converting these functions to string.

      Attachments

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              Unassigned Unassigned
              jark Jark Wu
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: