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 Subject: 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~ > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]