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

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

     [ 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)