Re: [Koha] group by hour sql?

2010/4/13 Ian Trim <ian.trim@kapiticoast.govt.nz>:

Hi all Looking to see busy times in the library. Can you GROUP BY hour? If so, how?

Query so far: mysql> select count(*),datetime from statistics where type='return' and date(datetime)='2010-04-12' and branch='k' group by datetime;

Hi Ian How's things up up the coast? This query should do what you want. mysql> select count(*),hour(datetime) as hourly from statistics where type='return' and date(datetime)='2010-04-12' and branch='k' group by hourly; Chris