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

Re: Setting timezone: is it bug or intended?

From: Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com>
To: Yura Sokolov <funny(dot)falcon(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Setting timezone: is it bug or intended?
Date: 2011-03-21 12:51:01
Message-ID: 4D8749B5.20407@2ndQuadrant.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello Yora Sokolov,

On 18.03.2011 09:22, Yura Sokolov wrote:
>
> postgres=# set timezone='+03:00';
> SET
> postgres=# select now();
>              now
> ------------------------------
>  2011-03-18 05:20:35.46008-03
> (1 row)

Maybe this is not a bug - just an inconsistence:

Look here (tested with 9.0):

=# set timezone='+3.5';
SET
=# select current_timestamp;
                now
----------------------------------
  2011-03-21 16:05:34.761112+03:30
(1 row)

In any case, this should get documented.

Susanne


-- 
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com


In response to

Responses

pgsql-bugs by date

Next:From: Susanne EbrechtDate: 2011-03-21 12:56:31
Subject: Re: BUG #5931: password when setup
Previous:From: Etienne RobillardDate: 2011-03-21 11:51:26
Subject: BUG #5937: initdb: FATAL error: could not open relation with OID 2608

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