Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Calcite has theĀ FormatModels class which is missing support for or has incorrect implementation for the following DATE-TIME format elements:
- SSSSS - seconds of the day (5 digits), only SS is available that gives seconds of the minute.
- FFn (n=1/2) - always returns seconds with precision 3 (=FF3); also BQ supports n=1-9, calcite format models supports n=1-6, should we expand this range?
- AM/PM - Meridian formats not available
Attachments
Issue Links
- is related to
-
CALCITE-6253 BigQuery FORMAT_DATE function does not implement all format specifiers
- Open
-
CALCITE-2980 Implement the FORMAT clause of the CAST operator
- Closed
- relates to
-
CALCITE-6358 Support all PostgreSQL 14 date/time patterns for to_char
- Resolved
-
CALCITE-6367 Add timezone support for FORMAT clause in CAST (enabled in BigQuery)
- Open
-
CALCITE-6375 Enable failing quidem tests for FORMAT in CAST
- Open
- links to