On 2013-10-29 Tue 11:34 AM |, Craig R. Skinner wrote:
>
> -- if a subscription is ceased same day it's started,
> -- that day is still chargable, so bump it
> IF billable_days < 1
> THEN
> billable_days := 1;
> END IF;
> ...
> ...
>
This is more accurate:
-- If a subscription billing_period ends part way through a day,
IF upper(billable_item.billable_period)::time <> time 'allballs'
THEN
-- That partial day is still chargable, so bump it
billable_days := billable_days + 1;
END IF;