Re: [DOCS] Add example about date ISO format - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: [DOCS] Add example about date ISO format
Date
Msg-id 39ac320937098e42241b947ec1165ae2003bc478.camel@cybertec.at
Whole thread Raw
In response to Re: [DOCS] Add example about date ISO format  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [DOCS] Add example about date ISO format
Re: [DOCS] Add example about date ISO format
List pgsql-docs
On Tue, 2023-11-21 at 23:33 -0500, Bruce Momjian wrote:
> On Fri, Feb 17, 2017 at 04:01:54PM +0000, juha.mustonen@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.

+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.

Yours,
Laurenz Albe



pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [DOCS] Add example about date ISO format
Next
From: Laurenz Albe
Date:
Subject: Re: [DOCS] intagg.sgml: example wrongly named and does not compile