On Thu, Jul 22, 2021 at 12:24 PM Bauyrzhan Sakhariyev <
baurzhansahar...@gmail.com> wrote:
>
> Is date_bin supposed to return the beginning of the bin?
Thanks for testing! And yes.
> And does the sign of an interval define the "direction" of the bin?
No, the boundary is intentionally the earlier one:
/*
* Make sure the returned timestamp is at the start of the bin, even if
* the origin is in the future.
*/
if (origin > timestamp && stride_usecs > 1)
tm_delta -= stride_usecs;
I wonder if we should just disallow negative intervals here.
--
John Naylor
EDB: http://www.enterprisedb.com
