Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group