mysql的created_at和updated at之间的时间差

Question

我的表created_at和updated_at中有2列，并且想知道如果时间大于20秒如何返回差异？

Answer 1

如果列是datetime值，那么使用timestampdiff函数应该可以工作:

SELECT TIMESTAMPDIFF(SECOND,created_at,updated_at) AS diff_in_secs 
FROM table
WHERE TIMESTAMPDIFF(SECOND,created_at,updated_at) > 20;

Example .