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