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 <kgri...@gmail.com> wrote: > On Wed, May 25, 2016 at 9:47 AM, Arnaud Inovia Team > <arnaud.bec...@inovia-team.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 >
