date_bin has big problem with DST.
In example, if you put origin in winter zone, then generated bin will be incorrect for summer input date.
date_trunc is resistant for this problem.
My version of date_trunc is additionally more flexible, you can select more granular interval, 12h, 8h, 6h, 15min, 10 min etc...
John Naylor wrote on 23.12.2023 01:32:On Sat, Dec 23, 2023 at 5:26 AM Przemysław Sztoch <przemyslaw@sztoch.pl> wrote:
In my opinion date_trunc is very good name.
Truncated data is timestamp type, not interval.
First parameter has same meaning in original date_trunc and in my new version.
New version provides only more granularity.
I haven't looked at the patch, but your description sounds awfully
close to date_bin(), which already takes an arbitrary interval.
--
Przemysław Sztoch | Mobile +48 509 99 00 66