News for hackers. Stuff that matters.
Re:PostgreSQL's Missing DateDiff Function by wruza on Tuesday December 21, 2021 @07:25PM (#29643913)
It means “spanned which legal-y periods”, I think. E.g. if a user is billed weekly, billing should ~group 2 weeks, even if login events happened at Sat and Mon. As a former accounting consultant/developer I can guess use cases like “group fixed assets by how many tax amortization quarters they already took part in, and then …”.
Re:PostgreSQL's Missing DateDiff Function by to11mtm on Tuesday December 21, 2021 @08:46PM (#29644632)
Lol my favorite case of this was where an org could by regulation be paid no less than 30 days apart, but could not take more than 1 payment per month, and could not take a payment on Sundays or banking holidays. Solve for X.
Re:PostgreSQL's Missing DateDiff Function by naniwaduni on Tuesday December 21, 2021 @11:42PM (#29645673)
Find the minimum and maximum maximum number of consecutive payments this org can take?