On Wed, May 30, 2012 at 3:50 AM, David Johnston <polobo(at)yahoo(dot)com> wrote:
> Any suggestions on how to obtain the number of “X minute” intervals in “Y”
> where “Y” is always less than 24 hours?
>
> e.g., : ‘05:00:00’::interval / ’00:06:00’::interval => 50 (integer)
Turn them into integer seconds:
select date_part('epoch','05:00:00'::interval)/date_part('epoch','00:06:00'::interval);
ChrisA