[
https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17605548#comment-17605548
]
Julian Hyde commented on CALCITE-5269:
--------------------------------------
In {{TIMESTAMP_TRUNC(timestamp_expression, date_time_part[, time_zone])}} (and
similar functions) I suggest:
* Skip time_zone for now (perhaps address it in a separate commit);
* Only support the following {{date_time_part}} values: MINUTE, HOUR, DAY,
WEEK, ISOWEEK, MONTH, QUARTER, YEAR, ISOYEAR. These are already supported by
Calcite. The missing {{date_time_part}} value is {{{}WEEK(<WEEKDAY>){}}}, e.g.
{{WEEK(THURSDAY)}} means the week starting on Thursday. That will be easier to
implement when CALCITE-5155 (extensible time frames) is done.
> Implement BigQuery DATE/TIMESTAMP_TRUNC functions
> -------------------------------------------------
>
> Key: CALCITE-5269
> URL: https://issues.apache.org/jira/browse/CALCITE-5269
> Project: Calcite
> Issue Type: Sub-task
> Reporter: TJ Banghart
> Assignee: TJ Banghart
> Priority: Major
>
> Implement missing BigQuery functions for:
> * DATE_TRUNC
> * DATETIME_TRUNC
> * TIME_TRUNC
> * TIMESTAMP_TRUNC
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
