timetz need more bytes than timestamptz

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: timetz need more bytes than timestamptz
Date: 2023-06-19 03:52:52
Message-ID: CACJufxGe=AR8biQNHs8hUq6qEz0mviwqBv0KCO3mox7MO=x8tw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
https://www.postgresql.org/docs/current/datatype-datetime.html
timetz, timestamptz:
same resolution.
fractional digits in the seconds field are also the same.
>
> All timezone-aware dates and times are stored internally in UTC. They are
converted to local time in the zone specified by the TimeZone configuration
parameter before being displayed to the client.

Why does timetz need more bytes (8 vs 12) than timestamptz?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Markus 2023-06-19 04:06:33 Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Previous Message shveta malik 2023-06-19 03:39:27 Re: Support logical replication of DDLs