[
https://issues.apache.org/jira/browse/CALCITE-5508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-5508:
---------------------------------
Fix Version/s: 1.34.0
> 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
> Fix For: 1.34.0
>
>
> 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)
