[
https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17803374#comment-17803374
]
Tanner Clary commented on CALCITE-6186:
---------------------------------------
Hey [~julianhyde] I added a Proof of Concept here:
https://github.com/tanclary/calcite/commit/72815dbbe6894d4bb4cb938b5dab090b28f1047b
Leave any comments, styling and whatnot will get cleaned up but wanted your
thoughts on the initial implementation.
> 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)
