[CALCITE-5464] Implement BigQuery DATE_ADD/DATE_DIFF

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.34.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 28/Dec/22 18:32
• Updated: 14/Mar/23 13:53
• Resolved: 27/Feb/23 03:18

Description

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

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

Issue Links

• links to: GitHub Pull Request #3025