You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2022/06/04 22:35:00 UTC
[jira] [Updated] (CALCITE-5180) Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME
[ https://issues.apache.org/jira/browse/CALCITE-5180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-5180:
---------------------------------
Description:
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;
* DATE_ADD, DATETIME_ADD, TIME_ADD, TIMESTAMP_ADD;
* DATE_SUB, DATETIME_SUB, TIME_SUB, TIMESTAMP_SUB;
* DATE_DIFF, DATETIME_DIFF, TIME_DIFF, TIMESTAMP_DIFF;
* DATE_TRUNC, DATETIME_TRUNC, TIME_TRUNC, TIMESTAMP_TRUNC;
* LAST_DAY;
* FORMAT_DATE, FORMAT_DATETIME, FORMAT_TIME, FORMAT_TIMESTAMP;
* PARSE_DATE, PARSE_DATETIME, PARSE_TIME, PARSE_TIMESTAMP.
The following functions are already implemented: CURRENT_DATETME, DATE(string), DATE_FROM_UNIX_DATE, TIMESTAMP_MICROS, TIMESTAMP_MILLIS, TIMESTAMP_SECONDS, UNIX_MICROS, UNIX_MILLIS, UNIX_SECONDS, UNIX_DATE.
was:
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.
> 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
> Priority: Major
>
> 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;
> * DATE_ADD, DATETIME_ADD, TIME_ADD, TIMESTAMP_ADD;
> * DATE_SUB, DATETIME_SUB, TIME_SUB, TIMESTAMP_SUB;
> * DATE_DIFF, DATETIME_DIFF, TIME_DIFF, TIMESTAMP_DIFF;
> * DATE_TRUNC, DATETIME_TRUNC, TIME_TRUNC, TIMESTAMP_TRUNC;
> * LAST_DAY;
> * FORMAT_DATE, FORMAT_DATETIME, FORMAT_TIME, FORMAT_TIMESTAMP;
> * PARSE_DATE, PARSE_DATETIME, PARSE_TIME, PARSE_TIMESTAMP.
> The following functions are already implemented: CURRENT_DATETME, DATE(string), DATE_FROM_UNIX_DATE, TIMESTAMP_MICROS, TIMESTAMP_MILLIS, TIMESTAMP_SECONDS, UNIX_MICROS, UNIX_MILLIS, UNIX_SECONDS, UNIX_DATE.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)