On 2013-01-28, c k wrote:
> --bcaec5014c15b72ffb04d459337f
> Content-Type: text/plain; charset=UTF-8
>
> Hi,
> I have two variables in pl/pgsql function.
> p_fromdate and p_todate
>
> I have another variable which represents intervals like day, month, quarter
> etc.
> p_interval as smallint, to h
On 2013-01-30, c k wrote:
> --bcaec54eebba86ab5904d4815b33
> Content-Type: text/plain; charset=UTF-8
>
> Thanks.
> After some hacking it solved my problems using
> select date_part('days', age('06/01/2010'::date ,'04/01/2010'::date));
>
??? you can't get there from here.
--
⚂⚃ 100% natural
-
Thanks.
After some hacking it solved my problems using
select date_part('days', age('06/01/2010'::date ,'04/01/2010'::date));
Regards,
On Mon, Jan 28, 2013 at 9:32 PM, Adrian Klaver wrote:
> On 01/28/2013 07:17 AM, c k wrote:
>
>> I know that. I have to check the period (dates entered by user
On 01/28/2013 05:24 AM, c k wrote:
Hi,
I have two variables in pl/pgsql function.
p_fromdate and p_todate
I have another variable which represents intervals like day, month,
quarter etc.
p_interval as smallint, to hold values like 1,2,3, which are
substituted for intervals as '1 day', '1 mont
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
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
On 01/28/2013 05:24 AM, c k wrote:
> Hi,
> I have two variables in pl/pgsql function.
> p_fromdate and p_todate
>
> I have another variable which represents intervals like day, month,
> quarter etc.
> p_interval as smallint, to hold values like 1,2,3, which are
> substituted for intervals as '1
Hi,
I have two variables in pl/pgsql function.
p_fromdate and p_todate
I have another variable which represents intervals like day, month, quarter
etc.
p_interval as smallint, to hold values like 1,2,3, which are substituted
for intervals as '1 day', '1 month - 1 day', '3 months - 1 day'
respecti
