[jira] [Created] (CALCITE-5180) Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME

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

Julian Hyde created CALCITE-5180:
------------------------------------

             Summary: Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME
                 Key: CALCITE-5180
                 URL: https://issues.apache.org/jira/browse/CALCITE-5180
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


Implement missing BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME.

Functions include:
* CURRENT_DATE, CURRENT_DATETIME, CURRENT_TIME with timezone;
* EXTRACT with time unit values WEEK(weekday), DATE, TIME;
* various DATE, TIME, TIMESTAMP, DATETIME constructor functions;
* TIMESTAMP_ADD, TIME_ADD, DATE_ADD, DATETIME_ADD
* TIMESTAMP_SUB, TIME_SUB, DATE_SUB, DATETIME_SUB
* TIMESTAMP_DIFF, TIME_DIFF, DATE_DIFF, DATETIME_DIFF
* TIMESTAMP_TRUNC, DATETIME_TRUNC
* LAST_DAY
* FORMAT_TIMESTAMP, FORMAT_DATETIME, 
* PARSE_TIMESTAMP, PARSE_DATETIME, 

CURRENT_DATETME, DATE(string), DATE_FROM_UNIX_DATE, TIMESTAMP_MICROS, TIMESTAMP_MILLIS, TIMESTAMP_SECONDS, UNIX_MICROS, UNIX_MILLIS, UNIX_SECONDS, UNIX_DATE are already implemented.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)