From: | rawi <only4com(at)web(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Time AT TIME ZONE: false result using offset instead of time zone name |
Date: | 2014-02-11 07:54:45 |
Message-ID: | 1392105285704-5791371.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-02-11 14:32:57 | Re: Time AT TIME ZONE: false result using offset instead of time zone name |
Previous Message | bricklen | 2014-02-05 16:15:48 | Re: IDENTIFY_SYSTEM |