Time AT TIME ZONE: false result using offset instead of time zone name

Поиск
Список
Период
Сортировка
От rawi
Тема Time AT TIME ZONE: false result using offset instead of time zone name
Дата
Msg-id 1392105285704-5791371.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Time AT TIME ZONE: false result using offset instead of time zone name  (Adrian Klaver <adrian.klaver@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: bricklen
Дата:
Сообщение: Re: IDENTIFY_SYSTEM
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Time AT TIME ZONE: false result using offset instead of time zone name