FRAC_SECOND。表示间隔是毫秒SECOND。秒MINUTE。分钟HOUR。小时DAY。天WEEK。星期MONTH。月QUARTER。季度YEAR。年 select TIMESTAMPDIFF(day,'2012-08-24','2012-08-30');