Re: MySql Timestamps

Something like:

select customer, avg(TIMEDIFF(dttmin, dttmout))
  from timetable
 group by customer;
[download]

Should get you pretty close.

Trek

Comment on Re: MySql Timestamps Download Code

Replies are listed 'Best First'.
Re^2: MySql Timestamps by TrekNoid (Pilgrim) on Jul 06, 2004 at 18:09 UTC
Correcting myself... I'm not so sure that the avg() function will work on timediff. My native DB is Oracle, and this sort of thing works there, but I can't vouch for MySQL. Sorry if I led you astray... Trek	[reply]