mysql timestampdiff()函数

timestampdiff(类型,开始时间,结束时间);

结束时间减开始时间

类型可以是second,minute,hour,day,week,month,year

SELECT created_at,deleted_at,timestampdiff( day, created_at, deleted_at ) AS num FROM users

SELECT created_at,deleted_at,timestampdiff( minute, created_at, deleted_at ) AS num FROM users