Re: [NOVICE] Does pg store all `timestamp with time zone` inlocaltime? Why?
| От | Greg Robson |
|---|---|
| Тема | Re: [NOVICE] Does pg store all `timestamp with time zone` inlocaltime? Why? |
| Дата | |
| Msg-id | CAFjXWtzv8EWgfYcYYwKp=v=Qt_fY4eh7PxZ2XUi25BzCySTggA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [NOVICE] Does pg store all `timestamp with time zone` inlocaltime? Why? (Alvaro Herrera <alvherre@2ndquadrant.com>) |
| Ответы |
Re: [NOVICE] Does pg store all `timestamp with time zone` inlocaltime? Why?
|
| Список | pgsql-novice |
Threre's a really good explanation of the data type, it's implementation, usage and how to insert/select values:
(This was one of those "this is why I love Postgres" moments!)
On 24 August 2017 at 14:00, Alvaro Herrera <alvherre@2ndquadrant.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: