Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6308 Add PostgreSQL functions up to PostgreSQL v14
  3. CALCITE-6392

Support all PostgreSQL 14 date/time patterns for to_date/to_timestamp

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 1.38.0
    • None

    Description

      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

      There are also template pattern modifiers that need to be supported.

      • FM (prefix)
      • TH (suffix)
      • th (suffix)
      • FX (prefix)
      • TM (prefix)

      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.

      Attachments

        Activity

          People

            njordan Norman Jordan
            njordan Norman Jordan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: