| From: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
|---|---|
| To: | Arnaud Inovia Team <arnaud(dot)becher(at)inovia-team(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Timestamp with timezone output |
| Date: | 2016-05-25 15:01:26 |
| Message-ID: | CACjxUsNBNqma82hr6cBLHhHuL_BPbrdnZhMvZJU16FE9njuGAg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Inovia Team | 2016-05-25 15:07:58 | Re: Timestamp with timezone output |
| Previous Message | Guillaume Lelarge | 2016-05-25 14:58:49 | Re: Timestamp with timezone output |