Just forwarding this to the list. On Wednesday, March 30, 2005 10:43, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:31 AM -0500 wrote: >> Look at the functions HOUR(time), MINUTE(time), SECOND(time). These >> will give you interger output for each part of the time field. Also >> TIME_TO_SEC(time) may be useful for you. I believe that all of these >> are supported in 3.23. If your times aren't greater than 838:59:59 >> this should work for you. > > Thanks for the help: > > SELECT sum( HOUR ( job_walltime ) ) Hours, sum( > MINUTE ( job_walltime ) ) Minutes, sum( > SECOND ( job_walltime ) ) Seconds > FROM `Jobs` > > This cold medicine that I'm on has slowed me down a bit. > > -Chris Vaughan > > www.clusters.umaine.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]