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)