From 7408c5d29b53fbeae0d88ab8121a42c3b4d9ed64 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 1 Jul 2013 13:40:18 -0400 Subject: Add timezone offset output option to to_char() Add ability for to_char() to output the timezone's UTC offset (OF). We already have the ability to return the timezone abbeviation (TZ/tz). Per request from Andrew Dunstan --- doc/src/sgml/func.sgml | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7c009d899cc..5765ddf576e 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -5645,6 +5645,10 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); tz lower case time-zone name + + OF + time-zone offset + -- cgit v1.2.3