MySQL – How to SUM times?

by

I think you have to use this code… it works 🙂

SELECT  
  SEC_TO_TIME( SUM( TIME_TO_SEC( `time` ) ) ) AS total_time  
FROM time_table;

More Related Contents:

  1. How to get a ranking result for special record in mysql [closed]
  2. How to reset AUTO_INCREMENT in MySQL
  3. MySQL Query GROUP BY day / month / year
  4. MySQL Server has gone away when importing large sql file
  5. What is MySQL row order for “SELECT * FROM table_name;”?
  6. MySQL Like multiple values
  7. Error: select command denied to user ”@” for table ”
  8. Problems with contenttypes when loading a fixture in Django
  9. How to convert time to the time zone of the iPhone device?
  10. MySQL: Sort GROUP_CONCAT values
  11. Entity Framework wizard crashes on MySQL
  12. Mysql to select month-wise record even if data not exist
  13. MySQL Trigger: Delete From Table AFTER DELETE
  14. Return a default value if single row is not found
  15. How to find out the MySQL root password
  16. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  17. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  18. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  19. How to restrict a column value in SQLite / MySQL
  20. How to get the max of two values in MySQL?
  21. Does MySQL foreign_key_checks affect the entire database?
  22. How to connect locally hosted MySQL database with the docker container
  23. how to partition a table by datetime column?
  24. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  25. GRANT with database name wildcard in MySQL?
  26. Using SUM on FLOAT data
  27. Duplicate entry for key ‘group_key’
  28. SQL query with avg and group by
  29. How can I rebuild indexes and update stats in MySQL innoDB?
  30. mysql – move rows from one table to another

Leave a Comment