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

[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              ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings