Time AT TIME ZONE: false result using offset instead of time zone name - Mailing list pgsql-sql

From rawi
Subject Time AT TIME ZONE: false result using offset instead of time zone name
Date
Msg-id 1392105285704-5791371.post@n5.nabble.com
Whole thread Raw
Responses Re: Time AT TIME ZONE: false result using offset instead of time zone name
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: bricklen
Date:
Subject: Re: IDENTIFY_SYSTEM
Next
From: Adrian Klaver
Date:
Subject: Re: Time AT TIME ZONE: false result using offset instead of time zone name