[CALCITE-1606] Add missing support for datetime JDBC functions

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Laurent Goujon
• Created: 26/Jan/17 21:39
• Updated: 09/May/22 19:20
• Resolved: 28/Jan/17 17:05

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.

Issue Links

• is depended upon by: CALCITE-1613 Implement EXTRACT for time unit DOW, DOY; and fix CENTURY
• is related to: CALCITE-282 Add {fn QUARTER(date)} function
• is related to: KYLIN-3041 support week function
• relates to: CALCITE-5135 Planner#parse can't parse DAY() function
• relates to: CALCITE-5118 SqlDatePartFunction#rewriteCall should check operands length