Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.4.0
    • Table SQL / API
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: