Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-14079 Full data type support in planner
  3. FLINK-14696

Support precision of TimestampType in built-in SQL functions and operators

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Table SQL / Planner
    • Labels:
      None

      Description

      Many built-in SQL functions and operators use long as internal representation of Timestamp type and only support millisecond precision. This ticket will check fix it and let them support nanosecond precision. The related SQL functions and operators are: 

      • timestamp compare
      • timestamp +/- interval
      • extract function
      • timestampadd/timestampdiff function
      • to_timestamp function
      • cast between timestamp with different precision

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                docete Zhenghua Gao
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: