Julian Hyde created CALCITE-5508:
------------------------------------
Summary: 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
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)
