Re: BUG #6605: wrong type cast from timestamp to timestamptz

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <eshkinkot(at)gmail(dot)com>,<tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6605: wrong type cast from timestamp to timestamptz
Date: 2012-04-22 16:51:48
Message-ID: 4F93F0D4020000250004720C@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Tom Lane wrote:
> eshkinkot(at)gmail(dot)com writes:
>> set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz;
>> SET
>> timestamptz
>> ------------------------
>> 2011-03-28 02:59:54+04
>
> Bizarre. On my Fedora 16 box, I see a different misbehavior:
>
> regression=# set timezone to 'Europe/Moscow'; select '2011-03-27
> 23:00:00'::timestamptz;
> SET
> timestamptz
> ------------------------
> 2011-03-28 00:29:40+04
> (1 row)

Ubuntu 10.04 LTS
Linux kevin-desktop 2.6.32-40-generic-pae #87-Ubuntu SMP
Mon Mar 5 21:44:34 UTC 2012 i686 GNU/Linux

PostgreSQL 9.2devel on i686-pc-linux-gnu,
compiled by gcc (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 32-bit

test=# set timezone to 'Europe/Moscow'; select '2011-03-27
23:00:00'::timestamptz;
SET
timestamptz
------------------------
2011-03-28 00:29:40+04
(1 row)

-Kevin

Browse pgsql-bugs by date

  From Date Subject
Next Message suvisor.root 2012-04-22 19:17:39 BUG #6607: Strange select behavior
Previous Message Gavin Flower 2012-04-21 21:29:24 Re: BUG #6605: wrong type cast from timestamp to timestamptz