You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Oliver Lee (Jira)" <ji...@apache.org> on 2023/01/25 22:50:00 UTC
[jira] [Created] (CALCITE-5497) Support time zones when parsing TIMESTAMP literals
Oliver Lee created CALCITE-5497:
-----------------------------------
Summary: Support time zones when parsing TIMESTAMP literals
Key: CALCITE-5497
URL: https://issues.apache.org/jira/browse/CALCITE-5497
Project: Calcite
Issue Type: Bug
Reporter: Oliver Lee
In Avatica, DateTimeUtils TIMESTAMP_FORMAT_STRING is {{DATE_FORMAT_STRING + " " + TIME_FORMAT_STRING}} which is {{"HH:mm:ss"}} with no handling for time zones if specified.
i.e. in Calcite quidem tests if we run
{\{DATETIME(TIMESTAMP "2008-12-25 05:30:00+00", "America/Los_Angeles") as datetime_tstz}}
the TIMESTAMP literal is not supported
--
This message was sent by Atlassian Jira
(v8.20.10#820010)