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]
So this is correct for years, right?