[
https://issues.apache.org/jira/browse/CALCITE-5432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary resolved CALCITE-5432.
-----------------------------------
Resolution: Fixed
> Implement BigQuery TIME_ADD/TIME_DIFF
> -------------------------------------
>
> Key: CALCITE-5432
> URL: https://issues.apache.org/jira/browse/CALCITE-5432
> Project: Calcite
> Issue Type: Sub-task
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Implement
> [TIME_ADD|https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_add]
> and
> [TIME_DIFF|https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_diff]
> functions (compatible with BigQuery)
> {{TIME_ADD(time_expression, INTERVAL int64_expression part)}} adds
> {{int64_expression }} units of {{part}} to the {{time}} object. For example,
> the outcome of:
> {{TIME_ADD(TIME '15:30:00', INTERVAL 5 MINUTE)}} is {{15:35:00}}.
> {{TIME_DIFF(time_expression_a, time_expression_b, part)}} finds the whole
> number of {{part}} between {{time_expression_a}} and {{time_expression_b}} .
> If {{time_expression_a}} is earlier than {{time_expression_b}}, the outcome
> is negative. For example, the outcome of:
> {{TIME_DIFF(TIME '15:30:00', TIME '15:40:00', MINUTE)}} is {{-10}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
