Surpassing MySQL’s TIME value limit of 838:59:59

by

Have a look at timestampdiff which doesn’t have the TIME limitation.
I.e. something like (untested):

SELECT CONCAT(
        TIMESTAMPDIFF(HOURS, entry_end_time, entry_start_time), 
        ":",
        MOD(TIMESTAMPDIFF(MINUTES, entry_end_time, entry_start_time),60)
      )
AS total FROM entry 
WHERE entry_date BETWEEN '2012-01-01' AND '2012-12-31' AND user_id = 3

The concats not ideal, I’m sure there will be a more elegant solution.

More Related Contents:

  1. Should MySQL have its timezone set to UTC?
  2. How to set a maximum execution time for a mysql query?
  3. MYSQL sum() for distinct rows
  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. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  8. MySQL sum elements of a column
  9. How do I add two count(*) results together on two different tables?
  10. Sum until certain point – MySql
  11. Mysql Average on time column?
  12. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  13. How to pivot a MySQL entity-attribute-value schema
  14. MySQL find_in_set with multiple search string
  15. Oracle Database Link – MySQL Equivalent?
  16. how to add super privileges to mysql database?
  17. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  18. Restoring deleted ‘root’ user and password for MySQL
  19. INTERSECT in MySQL
  20. MySQL select with CONCAT condition
  21. mysql field name from variable
  22. sql join tables where 1 column has comma
  23. MySQL IN condition limit
  24. MySQL Row Format: Difference between fixed and dynamic?
  25. See if lat / long falls within a polygon using mysql
  26. Xampp-mysql – “Table doesn’t exist in engine” #1932
  27. Unserialize through query at database level itself
  28. MySQL throws Incorrect string value error
  29. ORDER BY alphabet first then follow by number
  30. mysql create table dynamically

Leave a Comment