You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Tanner Clary (Jira)" <ji...@apache.org> on 2022/12/27 17:11:00 UTC
[jira] [Comment Edited] (CALCITE-5459) Implement BigQuery TIME() Function
[ https://issues.apache.org/jira/browse/CALCITE-5459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17652283#comment-17652283 ]
Tanner Clary edited comment on CALCITE-5459 at 12/27/22 5:10 PM:
-----------------------------------------------------------------
[~FrankZou] I completely agree, I think that is a great idea. There is [Calcite-5180 | https://issues.apache.org/jira/browse/CALCITE-5180] which is the parent issue for all BigQuery date/time functions and I have converted this issue as a sub-task of that. Is that what you had in mind? I can also create a parent issue for all BigQuery functions if you think that would be better. Sorry about the flood of BigQuery tickets! Thanks.
was (Author: JIRAUSER298151):
[~FrankZou] I completely agree, I think that is a great idea. There is [Calcite-5180 | https://issues.apache.org/jira/browse/CALCITE-5180] which is the parent issue for all BigQuery date/time functions and I have converted this issue as a sub-task of that. Is that what you had in mind? I can also create parent issue for all BigQuery functions if you think that would be better. Sorry about the flood of BigQuery tickets! Thanks.
> Implement BigQuery TIME() Function
> ----------------------------------
>
> Key: CALCITE-5459
> URL: https://issues.apache.org/jira/browse/CALCITE-5459
> Project: Calcite
> Issue Type: Sub-task
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
>
> Add support for BigQuery's {{TIME()}} function. The function constructs a {{TIME}} expression from the provided arguments.
> There are three ways the function can be called:
> 1. {{TIME(HOUR, MINUTE, SECOND)}}
> 2. {{TIME(TIMESTAMP [, TIMEZONE])}} (Calcite does not currently support timestamp with time zone.
> 3. {{TIME(DATETIME)}} (Calcite does not currently support DATETIME)
> Examples:
> {{TIME(5, 30, 50)}} would return '05:30:50'.
> {{TIME(TIMESTAMP '2008-12-25 15:30:00')}} would return '15:30:00'.
> [BigQuery Docs | https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)