-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have a table with session information, with a start and stop time.
I can aggregate the information, grouping it by hour or weekday. But, when I group it by hour and weekday, I need to also show the average usage, so I need to figure out how many Tuesdays are contained within 1/1/2004 - 5/1/2004, and I need to come up with a result where I know how many of each day of the week is within that date range. I am hoping someone may have a solution, as, once I know the number of Tues then I can state the average number of sessions on a Tuesday at 4pm. Thanx for any help. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCcPaMikQgpVn8xrARAoSKAJ96AzRIgGXnjbn/Krlxehz7K/HTlgCfSXZe VxslEjt9ERmUBiDJoBti3SE= =bwx8 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
