Date: Mon, 10 Feb 2014 23:54:45 -0800 (PST)
From: rawi <only4com@web.de>
To: pgsql-sql@postgresql.org
Message-ID: <1392105285704-5791371.post@n5.nabble.com>
Subject: Time AT TIME ZONE: false result using offset instead of time zone
 name
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Hi,
I am living in the Central European Time (CET == GMT+1)

SELECT CURRENT_TIMESTAMP ;

now
timestamp with time zone
----------------------------
2014-02-11 08:21:52.83588+01

And I want this without time zone but also for my own time zone (checking AT
TIME ZONE); sure, I get it correct... the same...

SELECT CURRENT_TIMESTAMP AT TIME ZONE 'CET';

timezone
timestamp without time zone
----------------------------
2014-02-11 08:22:39.586382

But it would be easier to ask a specific time offset (got from a client
around the world), so for me +01 hour:

SELECT CURRENT_TIMESTAMP AT TIME ZONE 'UTC+01';

timezone
timestamp without time zone
---------------------------
2014-02-11 06:23:07.043479

!!! Two hours earlyer, one hour to the east (Azores), not to the west of
Greenwich.
To get my time one hour west from Greenwich I have to ask:

SELECT CURRENT_TIMESTAMP AT TIME ZONE 'UTC-01';

Is this inverse calculation intently?

Thank you!
Regards, Rawi


--
View this message in context: http://postgresql.1045698.n5.nabble.com/Time-AT-TIME-ZONE-false-result-using-offset-instead-of-time-zone-name-tp5791371.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql