pgsql: Implement TZH and TZM timestamp format patterns

Started by Andrew Dunstanover 8 years ago1 messagescomitters
Jump to latest
#1Andrew Dunstan
andrew@dunslane.net

Implement TZH and TZM timestamp format patterns

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.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/11b623dd0a2c385719ebbbdd42dd4ec395dcdc9d

Modified Files
--------------
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(-)