From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | c k <shreeseva(dot)learning(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: finding if a period is multiples of a given interval |
Date: | 2013-01-28 16:02:22 |
Message-ID: | 5106A10E.2050900@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/28/2013 07:17 AM, c k wrote:
> I know that. I have to check the period (dates entered by user) must be
> correct and must be perfectly divisible by the interval given. This is a
> pre-check for the interest calculation.
>
> If user enters '01/04/2010' and '15/05/2010' as the dates, and interval
> as 'month' then, there are 15 days left and if the banking product is
> set to calculate interest for a complete month only, then calculation
> can result in wrong interest figures. So I have to check if given period
> is perfectly divisible by the interval or not.
I changed the dates to match my date_style.
test=> select age('05/15/2010'::date ,'04/01/2010'::date)
test-> ;
age
---------------
1 mon 14 days
(1 row)
test=> select date_part('days', age('05/15/2010'::date
,'04/01/2010'::date));
date_part
-----------
14
(1 row)
test=> select age('06/01/2010'::date ,'04/01/2010'::date)
;
age
--------
2 mons
(1 row)
test=> select date_part('days', age('06/01/2010'::date
,'04/01/2010'::date));
date_part
-----------
0
(1 row)
>
> Regards,
> C P Kulkarni
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2013-01-28 16:15:55 | Re: Installing PostgreSQL on OSX Server |
Previous Message | c k | 2013-01-28 15:17:17 | Re: finding if a period is multiples of a given interval |