Search Postgresql Archives

Re: Timestamp with vs without time zone.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2021-09-21 12:58:13 -0700, David G. Johnston wrote:
> On Tuesday, September 21, 2021, Peter J. Holzer <hjp-pgsql@xxxxxx> 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@xxxxxx         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment: signature.asc
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux