Re:PostgreSQL's Missing DateDiff Function
by mr_toad on Tuesday December 21, 2021 @08:49PM
(#29644645)
> These are used pretty often when doing data analysis.
In my experience you almost always want to count intervals for analysis and not interval boundaries. For example when calculating someone’s age in years.
The use cases for interval boundaries seem to mostly be businesses rules based on contract dates.
In my experience you almost always want to count intervals for analysis and not interval boundaries. For example when calculating someone’s age in years.
The use cases for interval boundaries seem to mostly be businesses rules based on contract dates.