On Mon, 2005-02-21 at 21:49 +0000, Lloyd Thomas wrote: > I have a query which calculates the number of events during an hour by the > minute. It needs to work out which minute has the most events and the > average events during that hour. So it should return an array of 60 results > for an hour where I can use the MAX() feature in php to find the peak > minute. >
How are you storing time values? Julian day number/ Number of seconds since 1970? IS09601? And what is the schema for the table you are querying? -- D. Richard Hipp <[EMAIL PROTECTED]>
