Calculating time difference between 2 dates in minutes

by

If you have MySql version above 5.6 you could use TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2) something like 

select * from MyTab T where
TIMESTAMPDIFF(MINUTE,T.runTime,NOW()) > 20

More Related Contents:

  1. Group mysql query by 15 min intervals
  2. How to select rows that have current day’s timestamp?
  3. When is a timestamp (auto) updated?
  4. how to delete data from table A besides the customer service and director data in table B?
  5. SQL split values to multiple rows
  6. Get records with max value for each group of grouped SQL results
  7. How to populate a table with a range of dates?
  8. MYSQL OR vs IN performance
  9. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  10. How to find gaps in sequential numbering in mysql?
  11. Convert timestamp to date in MySQL query
  12. Update a column value, replacing part of a string
  13. MySQL: View with Subquery in the FROM Clause Limitation
  14. MySql export schema without data
  15. MySQL combine two columns into one column
  16. MySQL Insert Into from one Database in another
  17. MySQL: LIMIT by a percentage of the amount of records?
  18. limiting the rows to where the sum a column equals a certain value in MySQL
  19. MySQL multiple columns in IN clause
  20. MySQL Inner Join Query Multiple Tables
  21. GROUP BY – do not group NULL
  22. Composite key as foreign key (sql)
  23. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  24. MySQL LEFT JOIN 3 tables
  25. How to select data where a field has a min value in MySQL?
  26. Update MySQL with if condition
  27. “Unknown column in ‘field list'”, but column does exist
  28. How do I combine the results of two queries with ordering?
  29. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  30. MYSQL Select One Random record from each Category

Leave a Comment