[ https://issues.apache.org/jira/browse/CALCITE-6252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815484#comment-17815484 ]
Mihai Budiu commented on CALCITE-6252: -------------------------------------- {color:#3367d6}SELECT{color}{color:#3a474e} {color}{color:#3367d6}format_date{color}{color:#37474f}({color}{color:#0d904f}'%A'{color}{color:#3a474e},{color}{color:#0d904f}'1582-01-01'{color}{color:#37474f}){color}{color:#3a474e}, {color}{color:#3367d6}format_date{color}{color:#37474f}({color}{color:#0d904f}'%A'{color}{color:#3a474e},{color}{color:#0d904f}'1582-12-12'{color}{color:#37474f}){color}{color:#3a474e}, {color}{color:#3367d6}format_date{color}{color:#37474f}({color}{color:#0d904f}'%A'{color}{color:#3a474e},{color}{color:#0d904f}'1752-01-01'{color}{color:#37474f}){color}{color:#3a474e}, {color}{color:#3367d6}format_date{color}{color:#37474f}({color}{color:#0d904f}'%A'{color}{color:#3a474e},{color}{color:#0d904f}'1752-12-12'{color}{color:#37474f}){color}{color:#3a474e}, {color}{color:#3367d6}format_date{color}{color:#37474f}({color}{color:#0d904f}'%A'{color}{color:#3a474e}, {color}{color:#0d904f}'2024-02-07'{color}{color:#37474f}){color} {color:#37474f}{color:#37474f}BigQuery:Friday, Sunday, Saturday, Tuesday, Wednesday {color}{color} {color:#37474f}{color:#37474f}Calcite: Monday, Sunday, Saturday, Tuesday, Wednesday{color}{color} {color:#37474f}{color:#37474f}So it seems to be in 1582.{color}{color} > 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 > Priority: Minor > > 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)