Re: Timestamp with vs without time zone.

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Timestamp with vs without time zone.
Дата
Msg-id YUo71gLmdyEV/ZRY@hjp.at
обсуждение исходный текст
Ответ на Re: Timestamp with vs without time zone.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Timestamp with vs without time zone.  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
On 2021-09-21 12:58:13 -0700, David G. Johnston wrote:
> On Tuesday, September 21, 2021, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
>     These two values are completely indistinguishable. That's good for a
>     timestamp (they are the same time after all). But they are not a
>     "timestamp with time zone". The time zone is not part of the value but
>     of the environment.
>
>
> No, it’s inherent to the data type itself.  The data type has an implied time
> zone of UTC.  That is a reasonable definition of “with” in my book.

If you can store only a single value that's 0 bits of information (which
is exactly the storage used).

But I'm going to stop arguing here. I'm obviously not able to convince
you and you aren't going to convince me either.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Вложения

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Timestamp with vs without time zone.
Следующее
От: cen
Дата:
Сообщение: Re: Timestamp with vs without time zone.