Re: Timestamp with vs without time zone.

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Timestamp with vs without time zone.
Дата
Msg-id 20211007182307.GA5476@momjian.us
обсуждение исходный текст
Ответ на Re: Timestamp with vs without time zone.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Nikhil Benesch
Дата:
Сообщение: Re: DELETE ... USING LATERAL
Следующее
От: Gavin Roy
Дата:
Сообщение: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14