Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.36.0
Description
For the following query:
SELECT format_date('%A %d %B %Y', '0001-01-01')
the BigQuery playground returns the following result:
Monday 01 January 1
However, Calcite returns the following result:
Saturday 01 Jan 1
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.
Attachments
Issue Links
- is related to
-
CALCITE-5619 Support PostgreSQL's TO_CHAR function
- Closed
-
CALCITE-5543 Implement BigQuery functions for parsing DATE, TIME, TIMESTAMP, DATETIME
- Closed
- links to