[jira] [Commented] (CALCITE-5459) Implement BigQuery TIME() Function

["Zou (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17652201#comment-17652201 ] 

Zou commented on CALCITE-5459:
------------------------------

Recently, a lot of ticket have been created to implement various BigQuery functions, maybe it is better to create an umbrella ticket and gather all the separated ones. What do you think?

> Implement BigQuery TIME() Function
> ----------------------------------
>
>                 Key: CALCITE-5459
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5459
>             Project: Calcite
>          Issue Type: Improvement
>            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)