Mihai Budiu created CALCITE-6253:
------------------------------------
Summary: BigQuery FORMAT_DATE function does not implement all
format specifiers
Key: CALCITE-6253
URL: https://issues.apache.org/jira/browse/CALCITE-6253
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Mihai Budiu
The following query:
{code:sql}
SELECT
format_date('%A,%a,%B,%b,%C,%D,%d,%e,%F,%G,%g,%h,%j,%m,%U,%u,%V,%W,%w,%x,%Y,%y,%t,%%','2024-02-07')
{code}
produces the following output in Calcite:
{code}
Wednesday,Wed,Feb,Feb,%C,%D,07,07,2024-02-07,%G,%g,%h,038,02,%U,4,06,06,%w,02/07/24,2024,24,%t,%%
{code}
The expected output, checked in the BigQuery playground, is:
{code}
Wednesday,Wed,February,Feb,20,02/07/24,07,
7,2024-02-07,2024,24,Feb,038,02,05,3,06,06,3,02/07/24,2024,24,\t,%
{code}
This implies that the following format specifiers are not implemented: %C, %D,
%G, %g, %h, %U, %w, %t, %%.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
