Re: timezone() with timeofday() converts the wrong direction?

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: timezone() with timeofday() converts the wrong direction?
Дата
Msg-id 20050425180212.D562@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: timezone() with timeofday() converts the wrong direction?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, Apr 25, 2005 at 11:36:23AM -0400, Tom Lane wrote:

> > -------------------------------+-------------------------------
> >  2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218+01
>
> It was not really possible in 7.1 either (nor any previous version).
> The secret to the above is that in 7.1 the timezone() function's
> result is *text*, not a timestamp object.  So it's purely a display
> artifact ...
Aha, there's the explanation. Thanks, Tom.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: DDL from psql console?
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: What does "tuple concurrently updated" mean?