[ https://issues.apache.org/jira/browse/CALCITE-6252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mihai Budiu resolved CALCITE-6252. ---------------------------------- Resolution: Fixed Fixed in https://github.com/apache/calcite/commit/3bce23210b0149857ddab80200090735291a6a5d > BigQuery FORMAT_DATE uses the wrong calendar for Julian dates > ------------------------------------------------------------- > > Key: CALCITE-6252 > URL: https://issues.apache.org/jira/browse/CALCITE-6252 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.36.0 > Reporter: Mihai Budiu > Assignee: Mihai Budiu > Priority: Minor > Labels: pull-request-available > Fix For: 1.37.0 > > > For the following query: > {code:sql} > SELECT format_date('%A %d %B %Y', '0001-01-01') > {code} > the BigQuery playground returns the following result: > {code} > Monday 01 January 1 > {code} > However, Calcite returns the following result: > {code} > Saturday 01 Jan 1 > {code} > There are actually two bugs here: > - the day of the week is wrong > - the month name is displayed incorrectly. The latter is because of the > Locale.ROOT used in SimpleDateFormat. -- This message was sent by Atlassian Jira (v8.20.10#820010)