Hi,

I have a DB with mucho rows.
Each has a timestamp like: 2010-07-02 00:07:49

How can I get how many rows for each hour of the day?

for example:

00 - 10 rows.
01 - 12 rows.
02 - 9 rows.
03 - 10 rows.
04 - etc
05 - etc
06 -
07 -
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23

Thanks
G

Try

SELECT COUNT(*) as rowcount GROUP BY  hour(date_column);