Horton

Re: Please clarify that Timestamp with Timezone doesn't preserve the timezone.

Bruce Momjian <bruce@momjian.us>

View thread View on postgr.es
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dave Cramer <davecramer@postgres.rocks>, Robert Treat <rob@xzilla.net>, Kirk Parker <khp@equatoria.us>, Richard Neill <rjn@richardneill.org>, github@richardneill.org, pgsql-docs@lists.postgresql.org
Date: 2026-05-14T19:46:14Z
Lists: pgsql-docs

Attachments

On Thu, May 14, 2026 at 02:02:15PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Okay, here is the patch with "conversion".
> 
> timetz does store a UTC offset, so it needs to be discussed separately.
> I don't think applying the same verbiage to time and timestamp will
> produce anything except more confusion.

I see what you mean --- updated patch attached.

If we want to be more explicit we could change "including time zone
conversion" to "including time zone conversion to/from UTC".

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.