Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1606

Add missing support for datetime JDBC functions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.12.0
    • core
    • None

    Description

      Calcite advertises support for all datetime functions but implementations are missing for some of them.

      Since Calcite already supports EXTRACT(timeUnit FROM datetime), support could be added for the following functions: YEAR, MONTH, WEEK, DAYOFYEAR, DAYOFMONTH, DAYOFWEEK, HOUR, MINUTE, SECOND.

      Some concrete implementation (like WEEK) would be missing, but if RexImpTable is updated to support it, then it would be fully wired.

      Attachments

        Issue Links

          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1613 Implement EXTRACT for time unit DOW, DOY; and fix CENTURY

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-282 Add {fn QUARTER(date)} function

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. KYLIN-3041 support week function

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5135 Planner#parse can't parse DAY() function

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5118 SqlDatePartFunction#rewriteCall should check operands length

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              julianhyde Julian Hyde
              laurent Laurent Goujon
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: