Re: Timestamp with vs without time zone. - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Timestamp with vs without time zone.
Date
Msg-id YUo71gLmdyEV/ZRY@hjp.at
Whole thread Raw
In response to Re: Timestamp with vs without time zone.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Timestamp with vs without time zone.  (Steve Crawford <scrawford@pinpointresearch.com>)
List 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!"

Attachment

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Timestamp with vs without time zone.
Next
From: cen
Date:
Subject: Re: Timestamp with vs without time zone.