Re: Timestamp with timezone output

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
<https://www.facebook.com/pages/Inovia-Team/147815591928404>
<https://twitter.com/inoviateam>
<https://www.linkedin.com/company/1099225?trk=tyah&trkInfo=tarId%3A1414773408012%2Ctas%3Ainovia%2Cidx%3A2-3-6>

On Wed, May 25, 2016 at 5:01 PM, Kevin Grittner <kgrittn(at)gmail(dot)com> wrote:

> On Wed, May 25, 2016 at 9:47 AM, Arnaud Inovia Team
> <arnaud(dot)becher(at)inovia-team(dot)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
>