Date: Fri, 24 Nov 2023 12:29:19 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Erik Wienhold <ewie@ewie.name>, juha.mustonen@iki.fi,
	pgsql-docs@postgresql.org
Subject: Re: [DOCS] Add example about date ISO format
Message-ID: <ZWDdb09hcFs_jBc8@momjian.us>
References: <20170217160154.6101.52806@wrigleys.postgresql.org>
 <ZV2Eo8P4q_2_F1Qe@momjian.us>
 <39ac320937098e42241b947ec1165ae2003bc478.camel@cybertec.at>
 <ijnhw7ykfvzllqtqgwwm5vboz4ovfaxwxk3xhmgpzc62nbth6a@wvqdpbjzjxly>
 <ZV4zPkxh63PDTquu@momjian.us>
 <640f4d61c5b4119870f5ac7ca019da8aa85700d8.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="T42+g3uLk8eUPpaA"
Content-Disposition: inline
In-Reply-To: <640f4d61c5b4119870f5ac7ca019da8aa85700d8.camel@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/ZWDdb09hcFs_jBc8%40momjian.us>
Precedence: bulk


--T42+g3uLk8eUPpaA
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Nov 23, 2023 at 09:29:39AM +0100, Laurenz Albe wrote:
> On Wed, 2023-11-22 at 11:58 -0500, Bruce Momjian wrote:
> > Okay, I moved it into the "Note" section that talked about ISO 8601
> > output with "T", in the attached patch.
> 
> Fine by me, except that I would rather have "returns" or "produces"
> instead of the questionable verb "outputs".

The majority of people seem to want it in table 9.31, so I have moved it
there.  It does almost double the width of the displayed table though. 
You can see the new output here:

	https://momjian.us/tmp/pgsql/functions-formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE

Patch attached.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.

--T42+g3uLk8eUPpaA
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="iso.diff"

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 93f068edcf..4c15eed66f 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -8748,6 +8748,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
         <entry><literal>to_char(current_timestamp, 'FMDay,&nbsp;FMDD&nbsp;&nbsp;HH12:MI:SS')</literal></entry>
         <entry><literal>'Tuesday,&nbsp;6&nbsp;&nbsp;05:39:18'</literal></entry>
        </row>
+       <row>
+        <entry><literal>to_char(current_timestamp AT TIME ZONE
+        'UTC', 'YYYY-MM-DD"T"HH24:MI:SSZ')</literal></entry>
+        <entry><literal>'2022-12-06T05:39:18'</literal>,
+        <acronym>ISO</acronym> 8601 <literal>T</literal> format</entry>
+       </row>
        <row>
         <entry><literal>to_char(-0.1, '99.99')</literal></entry>
         <entry><literal>'&nbsp;&nbsp;-.10'</literal></entry>

--T42+g3uLk8eUPpaA--