Re: [SQL] # of 5 minute intervals in period of time ...

2005-12-14 Thread Bruno Wolff III
On Tue, Dec 13, 2005 at 18:34:36 -0400, "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > Is there a simpler way of doing this then: > > select (date_part('epoch', now()) - > date_part('epoch', now() - '30 days'::interval)) / ( 5 * 60 ); Are you trying to do this: select extract(epoch

[SQL] # of 5 minute intervals in period of time ...

2005-12-13 Thread Marc G. Fournier
Is there a simpler way of doing this then: select (date_part('epoch', now()) - date_part('epoch', now() - '30 days'::interval)) / ( 5 * 60 ); Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy