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

Add missing support for datetime JDBC functions

          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:
                      laurentgo Laurent Goujon
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: