[CALCITE-1177] Support more time units in EXTRACT function

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.8.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Venki Korukanti
• Created: 30/Mar/16 00:20
• Updated: 07/Oct/21 19:45
• Resolved: 05/Jun/16 22:34

Description

Currently extract function support following units YEAR, MONTH, DAY, HOUR, MINUTE, SECOND. Add support for more units: CENTURY, DECADE, DOW, DOY, EPOCH, MILLENNIUM, QUARTER, WEEK.

Definitions of these units is similar to Postgres: http://www.postgresql.org/docs/9.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT

Issue Links

• depends upon: CALCITE-1239 Upgrade to avatica-1.8.0
• depends upon: CALCITE-1179 Extend list of time units and time unit ranges
• is depended upon by: DRILL-4550 Add support more time units in extract function
• relates to: CALCITE-1175 extract() from PostgreSQL timestamp column throws org.apache.calcite.sql.SqlSyntax$6: SPECIAL
• relates to: CALCITE-1613 Implement EXTRACT for time unit DOW, DOY; and fix CENTURY
• links to: PR