top | item 29646321 (no title) castorp | 4 years ago I never understood the need for a datediff function. In Postgres (or Oracle) you just subtract two timestamps and use the resulting interval. It's a different approach to the same problem. discuss order hn newest michael-ax|4 years ago one is counting distance, the other one buckets. alias the fn name to datebucketdelta to make the different problems memorable individually. :) castorp|4 years ago Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
michael-ax|4 years ago one is counting distance, the other one buckets. alias the fn name to datebucketdelta to make the different problems memorable individually. :) castorp|4 years ago Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
castorp|4 years ago Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
michael-ax|4 years ago
castorp|4 years ago