[
https://issues.apache.org/jira/browse/CALCITE-5508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde reassigned CALCITE-5508:
------------------------------------
Assignee: Julian Hyde
> 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. 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
