Difference in minutes from two time fields in MySQL

by

For me this worked:

TIMESTAMPDIFF(MINUTE, T0.created, T0.modified)

Reference: https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_timestampdiff

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. Checking a table for time overlap?
  4. How do I get the first day of the week of a date in mysql?
  5. Surpassing MySQL’s TIME value limit of 838:59:59
  6. Mysql Average on time column?
  7. Which DB technology is sued to solve the following search issue? [closed]
  8. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  9. How should I resolve –secure-file-priv in MySQL?
  10. node-mysql multiple statements in one query
  11. MySQL server startup error ‘The server quit without updating PID file’
  12. Select last row in MySQL
  13. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  14. Difference between Key, Primary Key, Unique Key and Index in MySQL
  15. MySQL: Split comma separated list into multiple rows
  16. How to start MySQL with –skip-grant-tables?
  17. How can I access the MySQL command line with XAMPP for Windows?
  18. When to use STRAIGHT_JOIN with MySQL
  19. Remove Primary Key in MySQL
  20. Difference in MySQL JOIN vs LEFT JOIN
  21. Get most recent row for given ID
  22. Update a column in MySQL
  23. Is merge statement available in MySQL
  24. Mysql covering vs composite vs column index
  25. Insert/ Update random date in MySQL
  26. Replace null with 0 in MySQL
  27. AWS Aurora MySQL serverless: how to connect from MySQL Workbench
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. MySQL Auto increment primary key increases by 10

Leave a Comment