[
https://issues.apache.org/jira/browse/CALCITE-6816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924377#comment-17924377
]
Yu Xu edited comment on CALCITE-6816 at 2/6/25 7:24 AM:
--------------------------------------------------------
Hi [~julianhyde] ，thanks for attention for the issue！Currently seem had no
database(s) support this feature directly as I know，like Mysql user need to
do：1. compute the week number in the year by weekofyear；2. according the week
number to compute the number in the week. In my option this is not easy enough
for user to do this for the demand，and JDK had support this feature in
Calendar，maybe can support first in Calcite than let other database to support
it(which would not very hard for mysql/oracle to implement it)？Do you agree
with me :)
was (Author: JIRAUSER307770):
Hi [~julianhyde] ，thanks for attention for the issue！Currently not had
database(s) support this feature directly as I know，like Mysql user need to
do：1. compute the week number in the year by weekofyear；2. according the week
number to compute the number in the week. In my option this is not easy enough
for user to do this for the demand，and JDK had support this feature in
Calendar，maybe can support first in Calcite than let other database to support
it(which would not very hard for mysql/oracle to implement it)？Do you agree
with me :)
> Support DAY_OF_WEEK_IN_MONTH function format
> --------------------------------------------
>
> Key: CALCITE-6816
> URL: https://issues.apache.org/jira/browse/CALCITE-6816
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.38.0
> Reporter: Yu Xu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.39.0
>
>
> Currently DAY_OF_WEEK_IN_MONTH format not support, need to support it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
