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

Add missing support for datetime JDBC functions

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.12.0
    • Component/s: core
    • Labels:
      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

          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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: