[
https://issues.apache.org/jira/browse/CALCITE-6252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17817719#comment-17817719
]
Caican Cai edited comment on CALCITE-6252 at 2/15/24 3:47 PM:
--------------------------------------------------------------
[~mbudiu] Hello, I noticed that the to_char function of postgres also uses this
part of the code. Maybe we should modify the jira description. It seems that it
affects not only bigquery, but also postgres
was (Author: JIRAUSER302115):
[~mbudiu] Hello, I noticed that the to_char function of postgres also uses this
part of the code. Maybe we should modify the jira description.
> 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
> Priority: Minor
> Labels: pull-request-available
>
> 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)
