[
https://issues.apache.org/jira/browse/CALCITE-6315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17828503#comment-17828503
]
Norman Jordan commented on CALCITE-6315:
----------------------------------------
These template patterns are supported by PostgreSQL 14 and are missing from
Calcite. PostgreSQL 14 supports all of the template patterns 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
[Calcite PostgreSQL template
patterns|https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/format/FormatModels.java#L148]
[PostgreSQL 14 template
patterns|https://www.postgresql.org/docs/14/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE]
> Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP
> -------------------------------------------------
>
> Key: CALCITE-6315
> URL: https://issues.apache.org/jira/browse/CALCITE-6315
> Project: Calcite
> Issue Type: Sub-task
> Reporter: James Duong
> Priority: Minor
>
> PostgreSQL supports different format strings than the version we have
> implemented.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
