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

From Erik Wienhold
Subject Re: [DOCS] Add example about date ISO format
Date
Msg-id vjia6do4pkjzccmyo3m2ednylhdrqnqdzgdjz2jk3oxni7ucma@o6zscc2ozujd
Whole thread Raw
In response to Re: [DOCS] Add example about date ISO format  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: [DOCS] Add example about date ISO format
List pgsql-docs
On 2023-11-27 15:22 +0100, Alvaro Herrera wrote:
> On 2023-Nov-27, Erik Wienhold wrote:
> 
> > Two issues that I fixed in the attached patch:
> > 
> > * it's called "extended format" not "T format" (the "T" is mandatory
> >   anyway)
> 
> +1
> 
> > * the time zone was missing from the result output
> 
> This is wrong.  Actually, there's no timezone in value, because the use
> of the AT TIME ZONE operator makes the type be TIMESTAMP WITHOUT TIME
> ZONE.  You would notice this if you were to change the incorrect literal
> Z in your format string with "TZ" (which expands to empty), with "OF"
> (which expands to "+00"), or with "TZH:TZM" (which expands to the full
> timezone shift):

Thanks for the explanation.  Bruce used literal Z in the format string.
I just corrected the sample output to match the format.

Or we just use current_timestamp along with pattern TZH:TZM which also
adds less to the width of the displayed table in case Bruce is concerned
about that ;)

-- 
Erik



pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS
Next
From: Alvaro Herrera
Date:
Subject: Re: CONCURRENTLY in example of index of partitioned table