I haven't succeeded in being able to group by time. My timestamp field is yyyy-mm-dd hh:mm:ss. What I would like is have a query that will enable me to be to group on events say every 5 minutes.
I've played around with using time_to_sec(timestamp) to convert all the times to seconds and then group by the timestamp to return only distinct seconds (timestamp). the timestamp field is multivalued. Any thoughts Greg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php