From: | c k <shreeseva(dot)learning(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | finding if a period is multiples of a given interval |
Date: | 2013-01-28 13:24:51 |
Message-ID: | CAN2Y=uM+qVbNLrrn3jOWfQ2GCQMRr=BZLNNkObZMbnjzMEXdQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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'
respectively.
Now, I have to find if the period of given two dates (p_todate -
p_fromdate) is multiples of the given interval or not?
e.g. p_fromdate = '01/04/2010';
p_todate = '31/03/2013';
p_interval=3 (which is a quarter).
I need to find out if the period of ('31/03/2013' - '01/04/2010') clearly
multiple of a quarter and modulus = 0.
Important point is user can enter any dates and choose any interval to
check. 'Day' interval fits to any dates. For 'month' and others, number of
days, minutes, seconds are varying. So we can not use the fixed values for
them neither we can use '1 month - 1 day' or any interval in division. Also
we can not cast them to integers.
How to get it done?
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2013-01-28 13:39:38 | Re: JDBC - Need to declare variables for values in insert statement |
Previous Message | Bob Futrelle | 2013-01-28 12:11:35 | JDBC - Need to declare variables for values in insert statement |