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)