[jira] [Commented] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

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

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

Tanner Clary commented on CALCITE-6021:
---------------------------------------

[~julianhyde] Thanks for your work on that, I think I cleaned it up. Feel free to see the PR and leave a review.

> Add CURRENT_DATETIME function (enabled in BigQuery library)
> -----------------------------------------------------------
>
>                 Key: CALCITE-6021
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6021
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Tanner Clary
>            Assignee: Tanner Clary
>            Priority: Major
>              Labels: pull-request-available
>
> Calcite supports parsing and validation for the CURRENT_DATETIME function according to CALCITE-4297 . However a native implementation was never added.
> The docs for the function may be found here: 
>  https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#current_datetime
> An example:
> {{SELECT CURRENT_DATETIME([timezone])}} should return the current time as a {{DATETIME}} (a Calcite TIMESTAMP). There is an optional time zone argument.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)