Postgres Pro
Downloads
Home   >   mailing lists

# of 5 minute intervals in period of time ... - Mailing list pgsql-sql

From Marc G. Fournier
Subject # of 5 minute intervals in period of time ...
Date
Msg-id 20051213183044.X1070@ganymede.hub.org
Whole thread Raw
Responses Re: # of 5 minute intervals in period of time ...
List pgsql-sql
Tree view 
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: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-sql by date:

Previous
From: Christian Kratzer
Date:
Subject: Re: exporting Excel tables into PostgreSQL database with Python
Next
From: Daniel Hertz
Date:
Subject: Multi-row update w. plpgsql function