On 2023-11-22 10:14 +0100, Laurenz Albe wrote: > On Tue, 2023-11-21 at 23:33 -0500, Bruce Momjian wrote: > > 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. > > > > 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
This might be excessive, but should we have an example with other time zones? ISO 8601 is not limited to UTC. For example: YYYY-MM-DD"T"HH24:MI:SSOF or YYYY-MM-DD"T"HH24:MI:SSTZH:TZM Fractional seconds are also possible: YYYY-MM-DD"T"HH24:MI:SS,FF6 > > + date/time in <acronym>ISO</acronym> 8601 date/time format. > > + </para> > > + </listitem> > > + > > </itemizedlist> > > </para> > > > > +1 on the idea, but from the context it looks like you added that example > at the regular expression matching functions. > > I think the example had best be at "8.5.2. Date/Time Output", in > doc/src/sgml/datatype.sgml around line 2552. +1 for moving it to section 8.5.2. -- Erik