On Fri, Feb 17, 2017 at 04:01:54PM +0000, juha.musto...@iki.fi 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 <br...@momjian.us> 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>