On Fri, Feb 17, 2017 at 04:01:54PM +0000, [email protected] wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/functions-formatting.html
> Description:
>
> The documentation should include an example how to format datetime entry
> into most commonly known ISO format. This is a bit tricky as literal
> character needs to included with quotes:
>
> to_char(NOW(), 'YYYY-MM-DD"T"HH24:MI:SSZ')
I know this is a six-year-old idea, but it is still a good one. I have
developed the attached patch I would like to apply to master.
--
Bruce Momjian <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 93f068edcf..297cafb341 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -8489,6 +8489,14 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
</para>
</listitem>
+ <listitem>
+ <para>
+ <literal>to_char(current_timestamp AT TIME ZONE 'UTC',
+ 'YYYY-MM-DD"T"HH24:MI:SSZ')</literal> outputs the current UTC
+ date/time in <acronym>ISO</acronym> 8601 date/time format.
+ </para>
+ </listitem>
+
</itemizedlist>
</para>
