I have a table with a datetime column and I want to group by week. Any ideas on how to do this with a MySQL query? The table has a timein column, a timeout column and a column called elapsed. I want to sum the elapsed for each week. I know I can do this in the where clause by specifying a date range but it is possible to do this with group by?
Thanks, -- Scott Hill "A wretched soul, bruised with adversity, We bid be quiet when we hear it cry; But we were burdened with like weight of pain, As much or more we should ourselves complain." * William Shakespeare * "Before God we are equally wise - and equally foolish." * Albert Einstein * "All paid jobs absorb and degrade the mind." * Aristotle * "A banker is a fellow who lends you his umbrella when the sun is shining, but wants it back the minute it begins to rain." * Mark Twain * _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
