Will Noble created CALCITE-6062: ----------------------------------- Summary: Allow conversion of un-zoned timestamp strings to timestamp with local time zone Key: CALCITE-6062 URL: https://issues.apache.org/jira/browse/CALCITE-6062 Project: Calcite Issue Type: Bug Components: core Reporter: Will Noble
[This function|https://github.com/apache/calcite/blob/ce88348960e95e1c13da850b4422b2f49f022d93/core/src/main/java/org/apache/calcite/runtime/SqlFunctions.java#L4333] that implements conversion from strings to {{TIMESTAMP WITH LOCAL TIME ZONE}} uses {{TimestampWithTimeZoneString}}, which seems to have been a subtle mistake. That function is only used to implement {{CAST}} expressions from strings to TS w/ LTZ. Those expressions should allow for strings that do not have a time zone, e.g. {{CAST('2023-10-19 12:00:00' AS TIMESTAMP WITH LOCAL TIME ZONE)}}, but it currently cannot because the {{TimestampWithTimeZoneString}} class always expects a time zone string. In the case that no zone is included in the string, we should assume that the string expresses a timestamp in the data context time zone by defaul. -- This message was sent by Atlassian Jira (v8.20.10#820010)