Tanner Clary created CALCITE-6568:
-------------------------------------
Summary: Snowflake incorrectly unparses BigQuery's TIMESTAMP()
function
Key: CALCITE-6568
URL: https://issues.apache.org/jira/browse/CALCITE-6568
Project: Calcite
Issue Type: Bug
Reporter: Tanner Clary
BigQuery offers the
[TIMESTAMP()](https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp)
function which can be used to construct a BigQuery {{TIMESTAMP}} (a Calcite
{{TIMESTAMP_LTZ}}).
Currently if this function is invoked with Snowflake as the "target" dialect,
the {{RelToSqlConverter}} does not unparse it into the Snowflake analogue,
{{TIMESTAMP_LTZ}} [1]
[1] This migration guide identifies the Snowflake equivalent for many BigQuery
functions.
https://cloud.google.com/bigquery/docs/migration/snowflake-sql
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
