[ 
https://issues.apache.org/jira/browse/CALCITE-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jess Balint closed CALCITE-5450.
--------------------------------

Resolved in release 1.33.0 (2023-02-06)

> Add support for WEEK(WEEKDAY) for custom time frames to relevant functions
> --------------------------------------------------------------------------
>
>                 Key: CALCITE-5450
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5450
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Oliver Lee
>            Assignee: Oliver Lee
>            Priority: Minor
>             Fix For: 1.33.0
>
>
> Some BigQuery functions, such as {{EXTRACT}} and {{{}DATE_TRUNC{}}}, accept 
> the operand {{{}WEEK(weekday){}}}, where {{weekday}} is one of {{{}SUNDAY, 
> MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY{}}}. After this 
> change, any function that accepts {{WEEK}} or {{ISOWEEK}} timeframe will also 
> accept {{WEEK(SUNDAY)}} etc.
>  
> Note that {{WEEK}} is equivalent to {{WEEK(SUNDAY)}} and {{ISOWEEK}} is 
> equivalent to {{{}WEEK(MONDAY){}}}.
> In this change we also allow {{WEEKS}} as a synonym for {{{}WEEK{}}}, and 
> {{QUARTERS}} as a synonym for {{{}QUARTER{}}}.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to