Re: [GENERAL] Timestamp with timezone output

2016-05-25 Thread Arnaud Inovia Team
Ok, it seems the Daylight Savings Time is perfect explanation to me. Thanks y'all, you're the best ! *--* *Arnaud Becher* Paris - San Francisco 10 rue du Faubourg Poissonnière - 75010 Paris T. + 33 (0)6 17 15 52 43 http://www.inovia.fr <

Re: [GENERAL] Timestamp with timezone output

2016-05-25 Thread Kevin Grittner
On Wed, May 25, 2016 at 9:47 AM, Arnaud Inovia Team 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 ]---+--

Re: [GENERAL] Timestamp with timezone output

2016-05-25 Thread Guillaume Lelarge
Hi, Le 25 mai 2016 4:50 PM, "Arnaud Inovia Team" a écrit : > > 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 t

Re: [GENERAL] Timestamp with timezone output

2016-05-25 Thread Larry Rosenman
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.