From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, juha(dot)mustonen(at)iki(dot)fi, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: [DOCS] Add example about date ISO format |
Date: | 2023-11-27 15:52:20 |
Message-ID: | vjia6do4pkjzccmyo3m2ednylhdrqnqdzgdjz2jk3oxni7ucma@o6zscc2ozujd |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2023-11-27 18:02:59 | Re: CONCURRENTLY in example of index of partitioned table |
Previous Message | PG Doc comments form | 2023-11-27 15:05:25 | Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS |