Sam Mason <sam@samason.me.uk> wrote:
> [...]
>> I would assume
>> that you just have to convert A, B and C to seconds (since
>> epoch) and then use a normal integer division.
> The problem is that the Gregorian calender is far too complicated. For
> example, think what would happen with an interval of "months". It
> doesn't help converting to seconds because the length of a month in
> seconds changes depending on which year the month is in and which
> month you're actually dealing with. This makes any definition of
> "division" I've ever been able to think of ill defined and hence the
> above calculation won't work.
Yep, you would probably need some safety margin and add a
"WHERE" clause. I should have thought about that earlier as
I recently stumbled (again) over why "INTERVAL / INTERVAL"
was not defined.
Tim