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

Re: BUG #5552: incorrect returned value of time

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5552: incorrect returned value of time
Date: 2010-07-12 14:22:25
Message-ID: i1f8f2$dor$ (view raw or whole thread)
Lists: pgsql-bugs
На 12.07.2010 г. 10:16, Konstantin Kulikov написа:
> The following bug has been logged online:
> Bug reference:      5552
> Logged by:          Konstantin Kulikov
> Email address:      k(dot)e(dot)kulikov(at)gmail(dot)com
> PostgreSQL version: 8.3
> Operating system:   unix
> Description:        incorrect returned value of time
> Details:
> select current_timestamp at time zone 'GMT+3';
> will return actually 'GMT-3'

Excerpts from the docs ("8.5.3. Time Zones",

" - In addition to the timezone names and abbreviations, PostgreSQL will 
accept POSIX-style time zone specifications of the form STDoffset or 
STDoffsetDST, where STD is a zone abbreviation, offset is a numeric 
offset in hours west from UTC, and DST is an optional daylight-savings 
zone abbreviation, assumed to stand for one hour ahead of the given 


"Another issue to keep in mind is that in POSIX time zone names, 
positive offsets are used for locations west of Greenwich. Everywhere 
else, PostgreSQL follows the ISO-8601 convention that positive timezone 
offsets are east of Greenwich. ..."

Milen A. Radev

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-07-12 14:27:09
Subject: Re: BUG #5552: incorrect returned value of time
Previous:From: Tom LaneDate: 2010-07-12 14:18:40
Subject: Re: BUG #5553: Repeating the keyword DECLARE in the CREATE FUNCTION statement

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