On Wed, May 30, 2012 at 3:50 AM, David Johnston <polobo@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
