[
https://issues.apache.org/jira/browse/CALCITE-5508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17682282#comment-17682282
]
Julian Hyde commented on CALCITE-5508:
--------------------------------------
The fix for this case must include some kind of fix for CALCITE-5498, otherwise
Calcite CI will give errors when running under JDK 8.
> Add constructor functions for DATE, TIME, TIMESTAMP, DATETIME
> -------------------------------------------------------------
>
> Key: CALCITE-5508
> URL: https://issues.apache.org/jira/browse/CALCITE-5508
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Priority: Major
>
> Add "constructor" functions for DATE, TIME, TIMESTAMP, DATETIME. These are
> functions such as {{DATE(1969, 7, 20)}} that create date-time types and we
> informally call them "constructors".
> The functions are based on those in BigQuery, and would be enabled in the
> BigQuery library. Their names follow the terminology of BigQuery's type
> system, which is confusing when working in Calcite's type system. For example:
> * The function call {{DATETIME(1969, 7, 20, 16, 17, 40)}} returns a Calcite
> {{TIMESTAMP}}, a type that is called {{DATETIME}} in BigQuery. (Eagle landed
> at 4.17pm Houston time.)
> * Similarly, {{TIMESTAMP(DATE '1969-07-21', TIME '22:17:40')}} returns a
> Calcite {{TIMESTAMP WITH LOCAL TIME ZONE}} representing the same instant in
> UTC. That type is called {{TIMESTAMP}} in BigQuery.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
