Tanner Clary created CALCITE-6186:
-------------------------------------
Summary: Enable DATEDIFF for Snowflake, map to BigQuery equivalents
Key: CALCITE-6186
URL: https://issues.apache.org/jira/browse/CALCITE-6186
Project: Calcite
Issue Type: Improvement
Reporter: Tanner Clary
Assignee: Tanner Clary
(Any suggestions for a better title would be helpful).
Snowflake supports the DATEDIFF function:
https://docs.snowflake.com/en/sql-reference/functions/datediff
This is equivalent to the BigQuery TIMESTAMP/TIME/DATE/DATETIME_DIFF functions
according to:
https://cloud.google.com/bigquery/docs/migration/snowflake-sql#date_and_time_functions
The operands are reorder but otherwise the functions operate similarly
--
This message was sent by Atlassian Jira
(v8.20.10#820010)