[Koha] group by hour sql?

Ian Trim ian.trim at kapiticoast.govt.nz
Tue Apr 13 08:19:22 NZST 2010


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;

Cheers 
Ian

Ian Trim
Circulation Services Librarian 
Te Kaitiaki Pukapuka Wāhi Tuku
Paraparaumu Library
9 Iver Trask Place 
Paraparaumu
04 2964 797
Skype ian.trim 

Kapiti Coast District Council does not guarantee the accuracy or completeness of any information contained in this e-mail or attached files. Internet communications are not secure; therefore the Council does not accept legal responsibility for the contents of this message or attached files. The content of this email may express the view of the author and not the official position of the Council. Kapiti Coast District Council may monitor and store all outgoing and incoming email traffic. This e-mail is subject to copyright. Except in reply to the author, no part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. If you have received this e-mail in error, please advise the sender immediately by return e-mail, or telephone the author and delete all copies.

#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################

______________________________________________________________________________

This email has been scrubbed for your protection by SMX.
For more information visit http://smxemail.com
______________________________________________________________________________



More information about the Koha mailing list