[ 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)