2 messages in com.mysql.lists.win32Time summazion
FromSent OnAttachments
Rene Harder Olsen23 Sep 2004 06:27 
Petr Vileta23 Sep 2004 14:13 
Subject:Time summazion
From:Rene Harder Olsen (reh@tdc.dk)
Date:09/23/2004 06:27:01 AM
List:com.mysql.lists.win32

Hello all.

Can anyone help me with a question about making af sum og dureation expressed as time minut, what happens is I think is that Mysql is transforming the time field into seconds values so that it can be summarize. The only problem is that the values are not matching. To try to describe it at little more is that I have rows with time as 00:02:16 when it is tranfered into seconds it should show 136 of whatever it is that mysql has made a sum of. The command used is sum(fieldname) group by the unit to which I want to group for. Hoping that it makes sense.

Best Regards Rene