Re: Sum for time

i dont think its possible. you can do it by using time_to_sec() function of mysql and then sec_to_time after addition Hope that helps Nitin - Original Message - From: "Elly Wisata" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 19, 2004 10:08 AM

Sum for time

Hi *, Can somebody show me how to sum for time, my format is hh:mm:ss, need to do sum for the time as we usually sum a field with integer type. But I am not sure sum can use for time format. Thanks in advance ~Elle~