agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: rawi <only4com@web.de>
To: pgsql-sql@postgresql.org
Subject: Time AT TIME ZONE: false result using offset instead of time zone name
Date: Mon, 10 Feb 2014 23:54:45 -0800 (PST)
Message-ID: <1392105285704-5791371.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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-...
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

view thread (7+ messages)  latest in thread

Message-ID: <1392105285704-5791371.post@n5.nabble.com>
Permalink:  ../1392105285704-5791371.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1392105285704-5791371.post@n5.nabble.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: only4com@web.de
  Subject: Re: Time AT TIME ZONE: false result using offset instead of time zone name
  In-Reply-To: <1392105285704-5791371.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox