[
https://issues.apache.org/jira/browse/CALCITE-5432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary updated CALCITE-5432:
----------------------------------
Description:
Implement TIME_ADD and 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}}.
was:
Implement TIME_ADD and 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)}} would be
{{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)}} would be {{-10}}.
> 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
>
> Implement TIME_ADD and 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)
