Postgres Pro
Downloads
Home   >   mailing lists

timetz need more bytes than timestamptz - Mailing list pgsql-general

From jian he
Subject timetz need more bytes than timestamptz
Date
Msg-id CACJufxGe=AR8biQNHs8hUq6qEz0mviwqBv0KCO3mox7MO=x8tw@mail.gmail.com
Whole thread Raw
Responses Re: timetz need more bytes than timestamptz
List pgsql-general
Tree view

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?

pgsql-general by date:

Previous
From: James Cloos
Date:
Subject: deb’s pg_upgradecluster(1) vs streaming replication
Next
From: Thomas Markus
Date:
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.