[
https://issues.apache.org/jira/browse/CALCITE-5508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-5508:
---------------------------------
Description:
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.
was:
Add "constructor" functions for DATE, TIME, TIMESTAMP, DATETIME. These are
functions such as "DATE(1969, 7, 20)" that create date-time types. 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 {{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.
> 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)
