Calculate difference between two datetimes in MySQL

by

USE TIMESTAMPDIFF MySQL function. For example, you can use:

SELECT TIMESTAMPDIFF(SECOND, '2012-06-06 13:13:55', '2012-06-06 15:20:18')

In your case, the third parameter of TIMSTAMPDIFF function would be the current login time (NOW()). Second parameter would be the last login time, which is already in the database.

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. MySQL: Enable LOAD DATA LOCAL INFILE
  3. MySQL root access from all hosts
  4. Setting up MySQL and importing dump within Dockerfile
  5. SQL order string as number
  6. MySQL: Fastest way to count number of rows
  7. Find most frequent value in SQL column
  8. Rails 3 ActiveRecord: Order by count on association
  9. update multiple rows using limit in mysql?
  10. Speeding up row counting in MySQL
  11. MySQL ENUM type vs join tables
  12. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  13. MySQL – How to SUM times?
  14. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  15. mysql root password forgotten
  16. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  17. SQL unique varchar case sensitivity question
  18. In MySQL, can I defer referential integrity checks until commit
  19. How to insert Hindi language in Mysql
  20. Converting epoch number to human readable date in mysql
  21. How to make join queries using Sequelize on Node.js
  22. MySQL delete duplicate records but keep latest
  23. mysql like performance boost
  24. MySQL 5.6 – DENSE_RANK like functionality without Order By
  25. MySQL: Can I do a left join and pull only one row from the join table?
  26. List of Constraints from MySQL Database
  27. MySQL: Querying for unicode entities
  28. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  29. How do I extract Month and Year in a MySQL date and compare them?
  30. INSERT INTO fails with node-mysql

Leave a Comment