[jira] [Created] (CALCITE-5508) Add constructor functions for DATE, TIME, TIMESTAMP, DATETIME

["Julian Hyde (Jira)" <ji...@apache.org>]

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)