summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorAndrew Dunstan <andrew@dunslane.net>2018-01-09 14:25:05 -0500
committerAndrew Dunstan <andrew@dunslane.net>2018-01-09 14:25:05 -0500
commit11b623dd0a2c385719ebbbdd42dd4ec395dcdc9d (patch)
tree80eae679d8dac59a6e0ad6302c55db5715dba196 /doc/src
parenta77dd53f3089a3d6bf74966bfd3ab7e27537183b (diff)
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.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/func.sgml8
1 files changed, 8 insertions, 0 deletions
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
@@ -6074,6 +6074,14 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
(only supported in <function>to_char</function>)</entry>
</row>
<row>
+ <entry><literal>TZH</literal></entry>
+ <entry>time-zone hours</entry>
+ </row>
+ <row>
+ <entry><literal>TZM</literal></entry>
+ <entry>time-zone minutes</entry>
+ </row>
+ <row>
<entry><literal>OF</literal></entry>
<entry>time-zone offset from UTC
(only supported in <function>to_char</function>)</entry>