Tanner Clary created CALCITE-5449: ------------------------------------- Summary: Implement EXTRACT() Function for BigQuery Key: CALCITE-5449 URL: https://issues.apache.org/jira/browse/CALCITE-5449 Project: Calcite Issue Type: Sub-task Reporter: Tanner Clary Assignee: Tanner Clary
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|https://g3doc.corp.google.com/company/teams/googlesql/reference/date_functions.md#extract ] -- This message was sent by Atlassian Jira (v8.20.10#820010)