mysql 计算两个时间之间有多少分钟

SELECT

TIMESTAMPDIFF(MINUTE,

(DATE_FORMAT('2015-08-12 10:38:00','%Y-%m-%d %H:%i')),

(DATE_FORMAT('2015-08-12 10:38:59', '%Y-%m-%d %H:%i'))
)
FROM

DUAL

原文地址:https://www.cnblogs.com/jpfss/p/11155915.html