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 06:23:00 UTC

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

Tanner Clary created CALCITE-5459:
-------------------------------------

             Summary: Implement BigQuery TIME() Function
                 Key: CALCITE-5459
                 URL: https://issues.apache.org/jira/browse/CALCITE-5459
             Project: Calcite
          Issue Type: Improvement
            Reporter: Tanner Clary


Add support for BigQuery's {{TIME()}} function. The function constructs a {{TIME}} expression from the provided arguments. 

There are three ways the function can 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)