You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2024/01/04 20:14:00 UTC

[jira] [Created] (CALCITE-6186) Enable DATEDIFF for Snowflake, map to BigQuery equivalents

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)