[UPHPU] Database question

[Scott Hill]

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
*