[ https://issues.apache.org/jira/browse/CALCITE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Danny Chan updated CALCITE-3238: -------------------------------- Description: 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} was: 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} > 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 > > 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)