On Wed, May 25, 2016 at 9:47 AM, Arnaud Inovia Team <arnaud.becher@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
