You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Norman Jordan (Jira)" <ji...@apache.org> on 2024/04/10 17:47:00 UTC
[jira] [Created] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns
Norman Jordan created CALCITE-6358:
--------------------------------------
Summary: Support all PostgreSQL 14 date/time patterns
Key: CALCITE-6358
URL: https://issues.apache.org/jira/browse/CALCITE-6358
Project: Calcite
Issue Type: Sub-task
Reporter: Norman Jordan
Many of the date/time format patterns supported by PostgreSQL 14 are not supported in Calcite.
* HH
* US
* SSSS
* SSSSS
* AM
* A.M.
* am
* a.m.
* PM
* P.M.
* pm
* p.m.
* Y,YYY
* YYY
* Y
* IYYY
* IYY
* IY
* I
* BC
* B.C.
* bc
* b.c.
* AD
* A.D.
* ad
* a.d.
* MONTH
* month
* MON
* mon
* DAY
* day
* Dy
* dy
* IDDD
* ID
* TZH
* TZM
* OF
Some format patterns in Calcite behave differently from PostgreSQL 14.
* FF1
* FF2
* FF4
* FF5
* FF6
Also verify that the other existing format strings produce results that match PostgreSQL 14.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)