[ https://issues.apache.org/jira/browse/CALCITE-6186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17803374#comment-17803374 ]
Tanner Clary edited comment on CALCITE-6186 at 1/5/24 1:07 AM: --------------------------------------------------------------- Hey [~julianhyde] I added a Proof of Concept here: https://github.com/apache/calcite/pull/3613 Leave any comments, styling and whatnot will get cleaned up but wanted your thoughts on the initial implementation. was (Author: JIRAUSER298151): 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)