以分钟为单位计算两个日期之间的时间差

2022-01-13 00:00:00 timestamp sql mysql

我的 MySQL 数据库中有一个时间戳字段，它映射到我的 bean 中的 DATE 数据类型.现在我想要一个查询，通过它我可以获取数据库中当前时间戳与存储在数据库中的时间戳之间的差异大于 20 分钟的所有记录.

I have a field of time Timestamp in my MySQL database which is mapped to a DATE datatype in my bean. Now I want a query by which I can fetch all records in the database for which the difference between the current timestamp and the one stored in the database is > 20 minutes.

我该怎么做?

我想要的是:

SELECT * FROM MyTab T WHERE T.runTime - now > 20 minutes

是否有任何 MySQL 函数可以做到这一点，或者在 SQL 中有什么方法可以做到这一点?

Are there any MySQL functions for this, or any way to do this in SQL?

推荐答案

我想你可以使用 TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2) 类似

I think you could use TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2) something like

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

相关文章