diff options
| author | Tom Lane | 2017-02-20 15:05:01 +0000 |
|---|---|---|
| committer | Tom Lane | 2017-02-20 15:05:01 +0000 |
| commit | 8f2799c993316a3dc436e231630b670a1ebf1fbb (patch) | |
| tree | 9f959920e2695ec47440b525043ef95e620813a4 /doc/src | |
| parent | 045462960f7c30608ebd7085697f1402d1e1500c (diff) | |
Fix documentation of to_char/to_timestamp TZ, tz, OF formatting patterns.
These are only supported in to_char, not in the other direction, but the
documentation failed to mention that. Also, describe TZ/tz as printing the
time zone "abbreviation", not "name", because what they print is elsewhere
referred to that way. Per bug #14558.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index b4cc240c2cf..90fa6e99924 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -5740,15 +5740,18 @@ SELECT regexp_matches('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); </row> <row> <entry><literal>TZ</literal></entry> - <entry>upper case time-zone name</entry> + <entry>upper case time-zone abbreviation + (only supported in <function>to_char</>)</entry> </row> <row> <entry><literal>tz</literal></entry> - <entry>lower case time-zone name</entry> + <entry>lower case time-zone abbreviation + (only supported in <function>to_char</>)</entry> </row> <row> <entry><literal>OF</literal></entry> - <entry>time-zone offset</entry> + <entry>time-zone offset from UTC + (only supported in <function>to_char</>)</entry> </row> </tbody> </tgroup> |