Tanner Clary created CALCITE-5484: ------------------------------------- Summary: Implement BigQuery DATETIME_SUB Key: CALCITE-5484 URL: https://issues.apache.org/jira/browse/CALCITE-5484 Project: Calcite Issue Type: Sub-task Reporter: Tanner Clary
BigQuery's {{DATETIME_SUB(timestamp, interval)}} returns the timestamp that occurs {{interval}} before {{timestamp}}. Example: {{DATETIME_SUB(TIMESTAMP '2008-12-25 15:30:00', INTERVAL 5 MINUTE)}} would return: '2008-12-25 15:25:00'. [BigQuery docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_sub] -- This message was sent by Atlassian Jira (v8.20.10#820010)