Re: date_trunc function in interval version - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: date_trunc function in interval version
Date
Msg-id 3B71F299-B9AD-4DE9-967A-44128129F3EE@yandex-team.ru
Whole thread Raw
In response to Re: date_trunc function in interval version  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers

> On 18 Feb 2024, at 05:29, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
>
> I'm not very familiar with date_bin(), but is this issue inherent or
> could we maybe fix date_bin() to handle DST better?
>
> In particular, isn't part of the problem that date_bin() is defined only
> for timestamp and not for timestamptz? Also, date_trunc() allows to
> specify a timezone, but date_bin() does not.
>
>
> In any case, the patch needs to add the new stuff to the SGML docs (to
> doc/src/sgml/func.sgml), which now documents the date_trunc(text,...)
> variant only.

Hi Przemysław,

Please address above notes.
I’ve flipped CF entry [0] to “Waiting on author”, feel free to switch it back.

Thank you!


Best regards, Andrey Borodin.
[0] https://commitfest.postgresql.org/47/4761/


pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: Add Index-level REINDEX with multiple jobs
Next
From: "Andrey M. Borodin"
Date:
Subject: Re: Improving EXPLAIN's display of SubPlan nodes