You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2023/03/13 05:46:00 UTC
[jira] [Comment Edited] (CALCITE-5496) Support time zones when parsing TIMESTAMP WITH LOCAL TIME ZONE
[ https://issues.apache.org/jira/browse/CALCITE-5496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17699455#comment-17699455 ]
Julian Hyde edited comment on CALCITE-5496 at 3/13/23 5:45 AM:
---------------------------------------------------------------
[~sbienenstock], There doesn't seem to be anyone working on this right now.
If anyone starts work, they should click 'start progress'. We welcome contributions.
was (Author: julianhyde):
[~sbienenstock], There doesn't seem to be anyone working on this right now, [~oliverlee], If you start work, be sure to click 'start progress'.
> Support time zones when parsing TIMESTAMP WITH LOCAL TIME ZONE
> --------------------------------------------------------------
>
> 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 doesn't handle time zones.
> TIMESTAMP_FORMAT_STRING consists of {{DATE_FORMAT_STRING + " " + TIME_FORMAT_STRING}} which is {{"HH:mm:ss"}}
>
> i.e. in Calcite quidem tests if we run
> {{DATETIME(TIMESTAMP "2008-12-25 05:30:00+07", "America/Los_Angeles") as datetime_tstz}}
>
>
> 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)