Support "of", "tzh", and "tzm" format codes.
Robert Haas <rhaas@postgresql.org>
Support "of", "tzh", and "tzm" format codes. The upper case versions "OF", "TZH", and "TZM" are already supported, and all other format codes that are supported in upper case are also supported in lower case, so we should support these as well for consistency. Nitin Jadhav, with a tiny cosmetic change by me. Reviewed by Suraj Kharage and David Zhang. Discussion: http://postgr.es/m/CAMm1aWZ-oZyKd75+8D=VJ0sAoSwtdXWLP-MAWD4D8R1Dgandzw@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/formatting.c | modified | +8 −2 |
| src/test/regress/expected/timestamptz.out | modified | +65 −0 |
| src/test/regress/sql/timestamptz.sql | modified | +22 −0 |
Discussion
- Query about time zone patterns in to_char 14 messages · 2021-05-16 → 2022-03-15