On 2016-05-25 09:47, Arnaud Inovia Team wrote: > I have some question regarding some timezone behaviour. > > Documentation is saying: >> When a timestamp with time zone value is output, it is always converted from >> UTC to the current timezone zone, and displayed as local time in that zone. >> To see the time in another time zone, either change timezone or use the AT >> TIME ZONE construct (see Section 9.9.3). > > 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 ? > > Thank you for your help !
Daylight Savings Time? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 17716 Limpia Crk, Round Rock, TX 78664-7281
