Re: Timestamp with vs without time zone. - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Timestamp with vs without time zone.
Date
Msg-id 20211007182307.GA5476@momjian.us
Whole thread Raw
In response to Re: Timestamp with vs without time zone.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Sep 21, 2021 at 05:49:21PM -0400, Tom Lane wrote:
> I think there is plenty of application for timestamps that actually
> include (civil) time zones.  Calendaring, for example.  If I make an
> appointment to see a friend at 2PM some months from now, it's
> understood that that's in the local time zone; if some lawmakers take
> it on themselves to fool with the DST rules before then, we're still
> going to meet at 2PM local time.  And it'd be useful to know whether
> that now conflicts with appointments defined by reference to some
> other zone, so the easy way of "assume it's all local time" doesn't
> cut it.

I wrote a blog about this:

    https://momjian.us/main/blogs/pgblog/2017.html#September_27_2017

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

  If only the physical world exists, free will is an illusion.




pgsql-general by date:

Previous
From: Nikhil Benesch
Date:
Subject: Re: DELETE ... USING LATERAL
Next
From: Gavin Roy
Date:
Subject: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14