Re: Does pg store all `timestamp with time zone` in localtime? Why?

Threre's a really good explanation of the data type, it's implementation,
usage and how to insert/select values:
http://phili.pe/posts/timestamps-and-time-zones-in-postgresql/

(This was one of those "this is why I love Postgres" moments!)

On 24 August 2017 at 14:00, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:

> Yann Salaün wrote:
> > Hello,
> >
> > I was surprised to observe this behavior in psql (my time zone is GMT+2)
>
> No, it stores in UTC and converts back and forth as you store then in
> and as you read them out. It depends on the TimeZone configuration
> parameter each time. The TZ that was current when the value was stored,
> is itself NOT stored in the same column. You could add a column to
> store that TZ, if you wanted.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>