I am a data person and I never knew about the boundary counting.
Like you can have a `day diff` be 3 and the `week diff` be 1 and the `month diff` be 1
You can also have `day diff` be 25 and the `month diff` be 0.<p>I would love to know why warehouse do this because as a data person it confuses me and is even more confusing to explain to stakeholders.
Author here. I've used pg a ton in the past in production systems as an operational database. Never really missed having datediff.<p>Once we started using it as a data warehouse I noticed that function was missing -- most other data warehouses have it. Thought it would be worth providing an implementation since date stuff is annoying to do.