[CALCITE-5449] Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

• Type: Sub-task
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 20/Dec/22 19:35
• Updated: 24/Apr/23 15:57

Description

Implement BigQuery EXTRACT() Function. EXTRACT(part FROM date_expression) returns the value from the date_expression corresponding to the specified part. Calcite currently supports PostgreSQL' DATE_PART which has similar behavior.

Example: SELECT EXTRACT(DAY FROM DATE '2013-12-25') would return 25.

BigQuery Docs

Issue Links

• links to: GitHub Pull Request #3125