| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Dave Cramer <davecramer(at)postgres(dot)rocks>, Robert Treat <rob(at)xzilla(dot)net>, Kirk Parker <khp(at)equatoria(dot)us>, Richard Neill <rjn(at)richardneill(dot)org>, github(at)richardneill(dot)org, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Please clarify that Timestamp with Timezone doesn't preserve the timezone. |
| Date: | 2026-05-14 19:46:14 |
| Message-ID: | agYmhgPtEmi2QH_X@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Thu, May 14, 2026 at 02:02:15PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
| Attachment | Content-Type | Size |
|---|---|---|
| time_zone.diff | text/x-diff | 2.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2026-05-15 09:15:36 | Error in 18.4 release notes |
| Previous Message | Robert Treat | 2026-05-14 18:36:05 | Re: Please clarify that Timestamp with Timezone doesn't preserve the timezone. |