Mysql Average on time column?

by

Try this:

SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(`login`))) FROM Table1;

Test data:

CREATE TABLE `login` (duration TIME NOT NULL);
INSERT INTO `login` (duration) VALUES
('00:00:20'),
('00:01:10'),
('00:20:15'),
('00:06:50');

Result:

00:07:09

More Related Contents:

  1. Calculate Average of the largest values in multiple columns
  2. Should MySQL have its timezone set to UTC?
  3. How to set a maximum execution time for a mysql query?
  4. Checking a table for time overlap?
  5. How do I get the first day of the week of a date in mysql?
  6. Difference in minutes from two time fields in MySQL
  7. Surpassing MySQL’s TIME value limit of 838:59:59
  8. SQL query with avg and group by
  9. how to create mysql database backup file in windows [closed]
  10. Calculate date range between two rows
  11. remove duplicate records – mysql
  12. SQL query return data from multiple tables
  13. MySQL Creating tables with Foreign Keys giving errno: 150
  14. Inserting multiple rows in mysql
  15. How do I quickly rename a MySQL database (change schema name)?
  16. Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  17. Convert MySQL to SQlite [closed]
  18. MySQL query String contains
  19. ERROR 1067 (42000): Invalid default value for ‘created_at’
  20. Capitalize first letter. MySQL
  21. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  22. MySQL remote connection fails with “unknown authentication method”
  23. Import MySQL database into a SQL Server
  24. How does MySQL’s ORDER BY RAND() work?
  25. How create json format with group-concat mysql?
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. Escaping the colon character ‘:’ in JPA queries
  29. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  30. Dump only the data with mysqldump without any table information?

Leave a Comment