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