From: Bruce Momjian <bruce@momjian.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Erik Wienhold <ewie@ewie.name>
Cc: juha.mustonen@iki.fi
Cc: pgsql-docs@postgresql.org
Subject: Re: [DOCS] Add example about date ISO format
Date: Fri, 24 Nov 2023 12:29:19 -0500
Message-ID: <ZWDdb09hcFs_jBc8@momjian.us> (raw)
In-Reply-To: <640f4d61c5b4119870f5ac7ca019da8aa85700d8.camel@cybertec.at>
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>
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.
Attachments:
[text/x-diff] iso.diff (876B, ../ZWDdb09hcFs_jBc8@momjian.us/2-iso.diff)
download | inline diff:diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgmlindex 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, FMDD HH12:MI:SS')</literal></entry>
<entry><literal>'Tuesday, 6 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>' -.10'</literal></entry>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, laurenz.albe@cybertec.at, ewie@ewie.name, juha.mustonen@iki.fi
Subject: Re: [DOCS] Add example about date ISO format
In-Reply-To: <ZWDdb09hcFs_jBc8@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox