Rodrigo Rueda created CALCITE-6226: -------------------------------------- Summary: 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.36.0, 1.35.0, 1.34.0 Reporter: Rodrigo Rueda 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)