Group by datetime

Hi folks- This is my first post to any MySQL lists, so be gentle. If I'm posting SQL queries to the wrong forum, please direct me to the proper resources. Anyways, I have a simple schema that stores some IP accounting data. I'm attempting to extract the data, grouping by the service type

Re: Group by datetime [SUMMARY]

On Mar 29, 2005, at 10:38 PM, Jason Dixon wrote: Anyways, I have a simple schema that stores some IP accounting data. I'm attempting to extract the data, grouping by the service type (label), and also grouping by each 24-hour window/day from the datetime column (timestamp). I'm not sure how