Mihai Budiu created CALCITE-6252: ------------------------------------ Summary: BigQuery FORMAT_DATE seems to use 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
For the following query: {code:sql} SELECT format_date('%A %d %B %Y', '0001-02-28') {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)