Re: Unexpected date conversion results

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Unexpected date conversion results
Дата
Msg-id 2e2a34695d84a297e62a2996466fecf97005a2fb.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Unexpected date conversion results  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Unexpected date conversion results
Список 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 по дате отправления: