计算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 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.