Re: Interval Division Workaround Suggestions (sub-day intervals only)? - Mailing list pgsql-general

On Wed, May 30, 2012 at 3:50 AM, David Johnston <polobo@yahoo.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