[ https://issues.apache.org/jira/browse/CALCITE-6247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mihai Budiu resolved CALCITE-6247. ---------------------------------- Fix Version/s: 1.37.0 Resolution: Fixed Resolved in https://github.com/apache/calcite/commit/36532c7e23dbdc004eaf2975ce5c54ef51f3d282 > 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 > Priority: Trivial > Labels: pull-request-available > Fix For: 1.37.0 > > > 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)