[
https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17803348#comment-17803348
]
Julian Hyde commented on CALCITE-6186:
--------------------------------------
Yes, it's worth experimenting with stuff like that. Assuming we have good test
coverage for RelToSql you could be agile - try creating a map, maybe it works
for 80% of functions, and if later you find something that works for 90% of
functions you can change the map.
> 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
> Priority: Major
>
> (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)
