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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 21/Sep/23 20:37
• Updated: 10/Nov/23 11:34
• Resolved: 12/Oct/23 22:03

Description

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.

Issue Links

• is related to: CALCITE-6045 CURRENT_TIMESTAMP has incorrect return type
• links to: GitHub Pull Request #3457