MySQL函数---TIMESTAMPDIFF

TIMESTAMPDIFF用法: 
TIMESTAMPDIFF(interval,datetime_expr1,datetime_expr2) 
返回日期或日期时间表达式datetime_expr2- datetime_expr1的整数差（会四舍五入）

SELECT TIMESTAMPDIFF(YEAR,'2009-09-01 08:30:20','2009-12-01 09:20:10');  #0
SELECT TIMESTAMPDIFF(MONTH,'2009-09-01 08:30:20','2009-12-01 09:20:10'); #3
SELECT TIMESTAMPDIFF(DAY,'2009-09-01 08:30:20','2009-12-01 09:20:10'); #91
SELECT TIMESTAMPDIFF(HOUR,'2009-09-01 08:30:20','2009-09-01 09:30:30');  #0  后面的日期减前面的日期，不够1小时返回0
SELECT TIMESTAMPDIFF(MINUTE,'2009-09-01 08:30:20','2009-09-01 08:40:10'); #    9
SELECT TIMESTAMPDIFF(SECOND,'2009-09-01 08:30:20','2009-09-01 08:30:30'); #  10

1. FRAC_SECOND。表示间隔是毫秒
2. SECOND。秒
3. MINUTE。分钟
4. HOUR。小时
5. DAY。天
6. WEEK。星期
7. MONTH。月
8. QUARTER。季度
9. YEAR。年