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
>
