Re: How to query for Interval

I had a similar question a while ago.

select count( timestmp ) as cnt, date_trunc('hour', timestmp) as hour

from  process_table

where date_trunc('day', timestmp) between '2006-04-01' and '2006-04-11'

group by date_trunc('hour', timestmp);


I do not currently have access to postgresql to verify the syntax however.  But this is the gist
of it.

Regards,

Richard Broersma Jr.

--- Vishal Kashyap  <vishalonlist@gmail.com> wrote:

> Hi,
>
>
> I have a table with time stamps in it . These timestamp represent a event count.
> I just wanted to know how could I query such that I get a count of
> event per hour.
>
> Table structure is
>
> my_table(id serial, time_event timestamp,event varchar(200));
>
> I want to do something like
> select count(id) from  my_table where time_event in (every 1 hour);
>
> Any pointers / help would be appreciated
>
>
> --
> With Best Regards,
> Vishal Kashyap.
> http://www.vishal.net.in
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>