Re: Number of days in a tstzrange? - Mailing list pgsql-sql

On 30/10/13 23:40, Craig R. Skinner wrote:
> 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;
>
>
>
even for 1 second over???

I would expect any court of law to set a higher threshold!


Cheers,
Gavin