[ https://issues.apache.org/jira/browse/CALCITE-6226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811261#comment-17811261 ]
Rodrigo Rueda commented on CALCITE-6226: ---------------------------------------- Thanks, [~tanclary] I ended up fixing another issue with the weekday in the same PR. Please, let me know if any changes are needed. > Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE > ---------------------------------------------------- > > Key: CALCITE-6226 > URL: https://issues.apache.org/jira/browse/CALCITE-6226 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.34.0, 1.35.0, 1.36.0 > Reporter: Rodrigo Rueda > Priority: Major > Labels: pull-request-available > Fix For: 1.37.0 > > > > Doing: > {code:java} > FORMAT_DATE('%G-%V', DATE '2023-01-01'){code} > results in: > {code:java} > '%G-01'{code} > but should be: > {code:java} > 2022-52{code} > > The week is wrong because the ISOWEEK format function is not setting the > minimalDaysInFirstWeek to 4 and the ISOYEAR (%g or %G) was not implemented. -- This message was sent by Atlassian Jira (v8.20.10#820010)