[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] Number of days in a tstzrange?
From: Gavin Flower <GavinFlower () archidevsys ! co ! nz>
Date: 2013-10-30 18:21:50
Message-ID: 52714E3E.2080306 () archidevsys ! co ! nz
[Download RAW message or body]
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic