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/12/21 01:36:00 UTC

[jira] [Commented] (CALCITE-5450) Add to parser WEEK(WEEKDAY) for custom time frames

    [ https://issues.apache.org/jira/browse/CALCITE-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17650048#comment-17650048 ] 

Julian Hyde commented on CALCITE-5450:
--------------------------------------

Does one of these map to the existing WEEK? And another to the existing ISOWEEK?

> Add to parser WEEK(WEEKDAY) for custom time frames
> --------------------------------------------------
>
>                 Key: CALCITE-5450
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5450
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: 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)