Implement TZH and TZM timestamp format patterns

Enterprise / PostgreSQL - Andrew Dunstan [dunslane.net] - 9 January 2018 19:25 EST

These are compatible with Oracle and required for the datetime template language for jsonpath in an upcoming patch.

Nikita Glukhov and Andrew Dunstan, reviewed by Pavel Stehule.

11b623dd0a Implement TZH and TZM timestamp format patterns
doc/src/sgml/func.sgml | 8 ++++
src/backend/utils/adt/formatting.c | 69 +++++++++++++++++++++++++++--
src/test/regress/expected/horology.out | 30 +++++++++++++
src/test/regress/expected/timestamptz.out | 72 ++++++++++++++++++-------------
src/test/regress/sql/horology.sql | 6 +++
src/test/regress/sql/timestamptz.sql | 20 +++++----
6 files changed, 164 insertions(+), 41 deletions(-)

Upstream: git.postgresql.org


  • Share