MySQL 计算两个时间的差值

TIMESTAMPDIFF(type,exp2,exp1)

type:year,month,day,HOUR,min,second等

例如:select TIMESTAMPDIFF(SECOND,'2012-10-1 2:0:0','2012-10-1 2:0:3')

结果:3.

posted @ 2012-11-05 10:39  道楠特  阅读(1675)  评论(0编辑  收藏  举报