Re: Unexpected date conversion results - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Unexpected date conversion results
Date
Msg-id 2e2a34695d84a297e62a2996466fecf97005a2fb.camel@cybertec.at
Whole thread Raw
In response to Re: Unexpected date conversion results  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Unexpected date conversion results
List pgsql-general
On Fri, 2025-11-21 at 16:38 -0800, Adrian Klaver wrote:
> > There was a time, like version 9-dot-something, when the above queries
> > performed as expected returning midnight in the current time zone but I
> > haven't been able to find a change document indicating this as an
> > expected change.
>
> I don't remember that, but as the gray content of the hair increases the
> memory is less solid:)

I dug into the git history, and it has been like that since commit b3506006b564
in 2002 (way before version 9.x).  That commit fixed a bug that returned ten
time the correct reault (but still offset from the UTC epoch).

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Unexpected date conversion results
Next
From: Tom Lane
Date:
Subject: Re: Unexpected date conversion results