Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.0
    • Component/s: Table SQL / API
    • Labels:
      None

      Description

      TIMESTAMPADD(unit,interval,datetime_expr) Adds the integer expression interval to the date or datetime expression datetime_expr. The unit for interval is given by the unit argument, which should be one of the following values: MICROSECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR.

      • Syntax:
        TIMESTAMPADD(unit,interval,datetime_expr)
      • Arguments
        **unit: -
        **interval: -
        **datetime_expr: -
      • Return Types
        DATAETIME/DATE/TIME
      • Example:
        SELECT TIMESTAMPADD(month, 1, '2017-05-31') --> '2017-06-30 00:00:00.000'
        SELECT TIMESTAMPADD(WEEK,1,'2003-01-02') -> '2003-01-09'

      Note: Due to the difference of [[org.apache.calcite.rex.Rex Literal]] between calcite 1.12 and calcite master we should temp close support the construce of TIMESTAMPADD(SqlTypeFamily.ANY, SqlTypeFamily.INTEGER, SqlTypeFamily.DATE), until upgrade to calcite 1.13.
      See more:
      https://issues.apache.org/jira/browse/CALCITE-1639
      https://issues.apache.org/jira/browse/FLINK-6851

      See more: https://issues.apache.org/jira/browse/CALCITE-1827

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sunjincheng121 sunjincheng
                Reporter:
                sunjincheng121 sunjincheng
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: