Unexpected behaviour of date_part

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Unexpected behaviour of date_part
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202FF668A@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответы Re: Unexpected behaviour of date_part  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
This is PostgreSQL 8.4, but the behaviour has not changed from earlier versions:

test=> SHOW timezone;
   TimeZone    
---------------
 Europe/Vienna
(1 row)

test=> SELECT date_part('timezone_hours', timestamp with time zone '2009-06-26 10:05:57.46624+11');
 date_part 
-----------
         2
(1 row)

2 being the offset of my local time zone.

Now an EXPLAIN shows that this is due to the fact that the timestamp
is converted to my local time zone before it is submitted to the function,
but I think that this result is undesirable and misleading.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: Sim Zacks
Дата:
Сообщение: Re: Free OLAP software for Postgres databas
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: masking the code