计算 MySQL 中两个日期时间之间的差异

2021-11-20 00:00:00 mysql

我正在将 MySQL 中的上次登录时间存储在 datetime 类型的文件中.当用户登录时，我想获得上次登录时间和当前时间(我使用 NOW() 获得的时间)之间的差异.

I am storing the last login time in MySQL in, datetime-type filed. When users logs in, I want to get the difference between the last login time and the current time (which I get using NOW()).

如何计算?

推荐答案

USE TIMESTAMPDIFF MySQL 函数.例如，您可以使用:

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

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

在您的情况下，TIMSTAMPDIFF 函数的第三个参数将是当前登录时间(NOW()).第二个参数是上次登录时间，该时间已经在数据库中.

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.

相关文章