[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Danny Chan resolved CALCITE-3238. --------------------------------- Resolution: Fixed Fix Version/s: 1.21.0 Fixed in [f25734a|https://github.com/apache/calcite/commit/f25734a2d27f304a454a310e656ab83a5fa85890] ! > Support Time Zone suffix of DateTime types for SqlDataTypeSpec > -------------------------------------------------------------- > > Key: CALCITE-3238 > URL: https://issues.apache.org/jira/browse/CALCITE-3238 > Project: Calcite > Issue Type: Sub-task > Reporter: Danny Chan > Assignee: Danny Chan > Priority: Major > Labels: pull-request-available > Fix For: 1.21.0 > > Time Spent: 20m > Remaining Estimate: 0h > > This is the grammar copied from SQL-2011: > {code:sql} > <datetime type> ::= > DATE > | TIME [ <left paren> <time precision> <right paren> ] [ <with or without > time zone> ] > | TIMESTAMP [ <left paren> <timestamp precision> <right paren> ] > [ <with or without time zone> ] > <with or without time zone> ::= > WITH TIME ZONE > | WITHOUT TIME ZONE > <time precision> ::= > <time fractional seconds precision> > <timestamp precision> ::= > <time fractional seconds precision> > <time fractional seconds precision> ::= > <unsigned integer> > {code} > We extend this grammar to support "with local time zone" definition: > {code:sql} > time(0) with local time zone > timestamp(0) with local time zone > {code} -- This message was sent by Atlassian JIRA (v7.6.14#76016)