[jira] [Created] (CALCITE-5497) Support time zones when parsing TIMESTAMP literals

[Oliver Lee (Jira)]

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)