Mihai Budiu created CALCITE-6247:
------------------------------------
Summary: BigQuery FORMAT_DATE function handles incorrectly the %e
format specifier
Key: CALCITE-6247
URL: https://issues.apache.org/jira/browse/CALCITE-6247
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Mihai Budiu
According to the BigQuery spec
https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements#format_elements_date_time
the %e format specified should mean: "The day of month as a decimal number
(1-31); single digits are preceded by a space."
However, the implementation in FormatModels.java BIGQUERY is:
{code:java}
map.put("%e", DD);
{code}
which is the same as %d, which uses a leading 0 instead of a space.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
