tanclary opened a new pull request, #3079: URL: https://github.com/apache/calcite/pull/3079
This PR adds implementations for BigQuery's DATETIME_ADD, DATETIME_DIFF, DATE_ADD, and DATE_DIFF functions. These were originally two separate JIRA Issues (links below) but I am opening them in one PR because they both rely on a change I made to the TimestampDiffConvertlet to correctly handle the WEEK time unit. That fix applies to TIME_DIFF, and TIMESTAMP_DIFF as well, which have already been merged. DATE_ADD adds an interval to a date. [BigQuery Docs](https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_add) DATETIME_ADD adds an interval to a datetime. [BigQuery Docs](https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_add) DATE_DIFF returns the whole number of a specified time unit between two dates. [BigQuery Docs](https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff) DATETIME_DIFF returns the whole number of a specified time unit between two datetimes. [BigQuery Docs](https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_diff) [DATE_ADD/DIFF JIRA Case](https://issues.apache.org/jira/browse/CALCITE-5464) [DATETIME_ADD/DIFF JIRA Case](https://issues.apache.org/jira/browse/CALCITE-5469) Any comments or suggestions would be much appreciated, thanks! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
