[CALCITE-1613] Implement EXTRACT for time unit DOW, DOY; and fix CENTURY

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 28/Jan/17 06:23
• Updated: 07/Oct/21 19:45
• Resolved: 01/Jun/17 15:46

Description

Implement EXTRACT for time units DOW, DOY and others introduced in CALCITE-1606.

Fix EXTRACT(CENTURY FROM ...), which previously just divided the year by 100, and a similar bug in MILLENNIUM.

Requires CALCITE-1609 and therefore has to wait for an Avatica release.

Issue Links

• depends upon: CALCITE-1608 Move addMonths and subtractMonths from Calcite to Avatica
• depends upon: CALCITE-1612 Release Avatica 1.10
• depends upon: CALCITE-1606 Add missing support for datetime JDBC functions
• is related to: CALCITE-1177 Support more time units in EXTRACT function
• relates to: CALCITE-4837 FLOOR and CEIL of DATE/TIMESTAMP return wrong results for DECADE, CENTURY and MILLENNIUM