finding if a period is multiples of a given interval

Поиск
Список
Период
Сортировка
От c k
Тема finding if a period is multiples of a given interval
Дата
Msg-id CAN2Y=uM+qVbNLrrn3jOWfQ2GCQMRr=BZLNNkObZMbnjzMEXdQw@mail.gmail.com
обсуждение исходный текст
Ответы Re: finding if a period is multiples of a given interval
Re: finding if a period is multiples of a given interval
Список 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?

В списке pgsql-general по дате отправления: