[ https://issues.apache.org/jira/browse/CALCITE-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-5464: ------------------------------------ Labels: pull-request-available (was: ) > 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 > Assignee: Tanner Clary > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > 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)