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.
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.
转载于:https://www.cnblogs.com/ja-net/archive/2012/11/05/2754724.html