Re: Inconsistency of timezones in postgresql - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Inconsistency of timezones in postgresql
Date
Msg-id CAKFQuwYmG+dxF=PWBUauUn6DcdbE_zXXs2-YA7EJ_fhQTf+vqQ@mail.gmail.com
Whole thread Raw
In response to Re: Inconsistency of timezones in postgresql  (Chris BSomething <xpusostomos@gmail.com>)
List pgsql-bugs
On Wednesday, July 31, 2024, Chris BSomething <xpusostomos@gmail.com> wrote:

Riddle me this... I have a field of type timestamp. I do 3 queries on a particular record one is AT TIME ZONE 'UTC', ones is AT TIME ZONE Australia/Sydney, one is plain, without a clause and I get: 



We are no longer in bug reporting territory.  Depesz wrote a good article on all this a while back.  I’d suggest reading it then following up further on the -general mailing list if you still have questions.


David J.

pgsql-bugs by date:

Previous
From: Chris BSomething
Date:
Subject: Re: Inconsistency of timezones in postgresql
Next
From: "David G. Johnston"
Date:
Subject: Re: Inconsistency of timezones in postgresql