Re: Timestamp with timezone output

On Wed, May 25, 2016 at 9:47 AM, Arnaud Inovia Team
<arnaud.becher@inovia-team.com> wrote:

> While using "psql", when selecting a column timestamp with
> timezone, I get results with different timezones:
>
> -[ RECORD 6 ]---+-----------------------
> expiration_date | 2015-09-07 00:00:00+02
> -[ RECORD 7 ]---+-----------------------
> expiration_date | 2015-11-27 00:00:00+01
>
> Shouldn't all value be converted to the same timezone ?

Perhaps your local time zone ends Daylight Saving Time between
those dates, so the offset from UTC is different on those dates?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company