From 11b623dd0a2c385719ebbbdd42dd4ec395dcdc9d Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Tue, 9 Jan 2018 14:25:05 -0500 Subject: 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. --- doc/src/sgml/func.sgml | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4dd9d029e69..2428434030b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6073,6 +6073,14 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); lower case time-zone abbreviation (only supported in to_char) + + TZH + time-zone hours + + + TZM + time-zone minutes + OF time-zone offset from UTC -- cgit v1.2.3