[
https://issues.apache.org/jira/browse/CALCITE-5496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oliver Lee updated CALCITE-5496:
--------------------------------
Description:
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+07", "America/Los_Angeles") as
datetime_tstz}}
the TIMESTAMP literal is not supported
Error:
{{Illegal TIMESTAMP WITH LOCAL TIME ZONE literal '2008-12-25 05:30:00+07': not
in format 'yyyy-MM-dd HH:mm:ss'}}
was:
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+07", "America/Los_Angeles") as
datetime_tstz}}
the TIMESTAMP literal is not supported
Illegal TIMESTAMP WITH LOCAL TIME ZONE literal '2008-12-25 05:30:00+07': not in
format 'yyyy-MM-dd HH:mm:ss'
> Support time zones when parsing TIMESTAMP literals
> --------------------------------------------------
>
> Key: CALCITE-5496
> URL: https://issues.apache.org/jira/browse/CALCITE-5496
> Project: Calcite
> Issue Type: Bug
> Reporter: Oliver Lee
> Priority: Major
>
> 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+07", "America/Los_Angeles") as
> datetime_tstz}}
>
> the TIMESTAMP literal is not supported
>
> Error:
>
> {{Illegal TIMESTAMP WITH LOCAL TIME ZONE literal '2008-12-25 05:30:00+07':
> not in format 'yyyy-MM-dd HH:mm:ss'}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
