[
https://issues.apache.org/jira/browse/CALCITE-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17678373#comment-17678373
]
Oliver Lee commented on CALCITE-5450:
-------------------------------------
I pushed a commit in my
[branch|https://github.com/olivrlee/calcite/tree/5450-week] adding in the
plural tests and updating reference.md
I tested quidem tests and yes ISOYEAR does not work with TimeUnit.ISOYEAR. If
it is sent in as a custom time frame with name "ISOYEAR" that seems to work.
I'll wait for the Avatica bump to followup and verify ISOYEAR works as TimeUnit.
> 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
>
> Some BIG_QUERY functions (i.e. {{{}EXTRACT(){}}}, {{DATE_TRUNC()}} ) can
> accept the operand
> {{WEEK(WEEKDAY)}} where {{WEEKDAY}} is one of {{SUNDAY, MONDAY, TUESDAY,
> WEDNESDAY, THURSDAY, FRIDAY, SATURDAY}}
>
> This is not currently supported.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
