Oliver Lee created CALCITE-5499: ----------------------------------- Summary: BigQuery TIMESTAMP_TRUNC() not fully implemented Key: CALCITE-5499 URL: https://issues.apache.org/jira/browse/CALCITE-5499 Project: Calcite Issue Type: Bug Reporter: Oliver Lee
BigQuery documentation shows that TIMESTAMP_TRUNC supports an optional 3rd argument, time zone Docs: [https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_trunc] The current implementation does not support that. {{SELECT timestamp_value AS timestamp_value, TIMESTAMP_TRUNC(timestamp_value, WEEK(MONDAY), "UTC") AS utc_truncated, TIMESTAMP_TRUNC(timestamp_value, WEEK(MONDAY), "Pacific/Auckland") AS nzdt_truncated FROM (SELECT TIMESTAMP("2017-11-06 00:00:00+12") AS timestamp_value); -- Display of results may differ, depending upon the environment and time zone where this query was executed. +-------------------------+-------------------------+-------------------------+ | timestamp_value | utc_truncated | nzdt_truncated | +-------------------------+-------------------------+-------------------------+ | 2017-11-05 12:00:00 UTC | 2017-10-30 00:00:00 UTC | 2017-11-05 11:00:00 UTC | +-------------------------+-------------------------+-------------------------+}} -- This message was sent by Atlassian Jira (v8.20.10#820010)