Tanner Clary created CALCITE-5464: ------------------------------------- Summary: Implement BigQuery DATE_ADD/DATE_DIFF Key: CALCITE-5464 URL: https://issues.apache.org/jira/browse/CALCITE-5464 Project: Calcite Issue Type: Sub-task Reporter: Tanner Clary
Add support for BigQuery DATE_ADD/DATE_DIFF functions. {{DATE_ADD(date_expression, interval)}} adds the interval to the date expression. Example: {{DATE_ADD(DATE '2008-12-25', INTERVAL 3 DAY)}} would return '2008-12-28'. [BigQuery docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_add] {{DATE_DIFF(date_expression, date_expression2, time_unit)}} returns the whole number of time_unit between the first and second date expressions, with the result being negative if the first date is earlier than the second. Example: {{DATE_DIFF(DATE '2008-12-25', DATE '2008-12-28', DAY)}} would return -3. [BigQuery docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff] -- This message was sent by Atlassian Jira (v8.20.10#820010)