News for hackers. Stuff that matters.
Re:PostgreSQL's Missing DateDiff Function by jeroenhd on Wednesday December 22, 2021 @06:48AM (#29648069)
Years aren't 365 days long, though. Technically, there are about 365.24 days in a year, but human dating doesn't take that into account well. The 3600 * 24 * 365 approach is tricky because there's a 1/4 chance that it'll work for you when you test it...

I don't think there's a good, mathematical expression for determining something as arbitrary as dates. If there was, I don't think MS would implement a special function like DateDiff for it.

Re:PostgreSQL's Missing DateDiff Function by funcDropShadow on Wednesday December 22, 2021 @08:40AM (#29649120)
So, it is this:

> # SELECT date_part('year', '2021-01-01'::timestamptz) - date_part('year', '2020-12-31'::timestamptz) as years;

Or what am I missing?

[edit: formatting]