| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Chris BSomething <xpusostomos(at)gmail(dot)com> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Inconsistency of timezones in postgresql |
| Date: | 2024-08-01 01:51:31 |
| Message-ID: | CAKFQuwYmG+dxF=PWBUauUn6DcdbE_zXXs2-YA7EJ_fhQTf+vqQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wednesday, July 31, 2024, Chris BSomething <xpusostomos(at)gmail(dot)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.
https://www.depesz.com/2014/04/04/how-to-deal-with-timestamps/
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-08-01 01:58:15 | Re: Inconsistency of timezones in postgresql |
| Previous Message | Chris BSomething | 2024-08-01 01:37:45 | Re: Inconsistency of timezones in postgresql |