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