Re: Timestamp with timezone output

Hi,

Le 25 mai 2016 4:50 PM, "Arnaud Inovia Team" <arnaud(dot)becher(at)inovia-team(dot)com>
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 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 ?
>

Are you sure this column is a timestamp? Can you show us the table
definition?