calculate a sum of type time using sql

by 
SELECT  SEC_TO_TIME( SUM( TIME_TO_SEC( `timeSpent` ) ) ) AS timeSum  
FROM YourTableName

This worked for me. Hope this helps.

More Related Contents:

  1. Join vs. sub-query
  2. Find records from one table which don’t exist in another
  3. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  4. How to use GROUP BY to concatenate strings in MySQL?
  5. Natural Sort in MySQL
  6. Best way to test if a row exists in a MySQL table
  7. MySQL get row position in ORDER BY
  8. Subqueries vs joins
  9. MySQL Results as comma separated list
  10. MySQL unknown column in ON clause
  11. MySQL not using indexes with WHERE IN clause?
  12. SQL: Find the max record per group [duplicate]
  13. Group by month and year in MySQL
  14. How do I convert from BLOB to TEXT in MySQL?
  15. Maintaining order in MySQL “IN” query
  16. MySQL: What is a reverse version of LIKE?
  17. Select TOP X (or bottom) percent for numeric values in MySQL
  18. MySQL select where column is not empty
  19. MySQL: GROUP_CONCAT with LEFT JOIN
  20. Hamming distance on binary strings in SQL
  21. Is it possible to have a default parameter for a mysql stored procedure?
  22. Renaming foreign-key columns in MySQL
  23. How to convert from varbinary to char/varchar in mysql
  24. MySQL GROUP BY behavior
  25. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  26. Update multiple rows with one query?
  27. How to find all IDs of children recursively?
  28. How to implement a Keyword Search in MySQL?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment