[ 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)