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 ______________________________________________________________________________