[CALCITE-3238] Support Time Zone suffix of DateTime types for SqlDataTypeSpec

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Danny Chen
• Created: 09/Aug/19 10:03
• Updated: 29/Jun/20 02:20
• Resolved: 14/Aug/19 08:49

Description

This is the grammar copied from SQL-2011:

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

We extend this grammar to support "with local time zone" definition:

time(0) with local time zone
timestamp(0) with local time zone

Issue Links

• links to: GitHub Pull Request #1371