返回日期或日期時(shí)間表達(dá)式datetime_expr1和datetime_expr2之間的整數(shù)差。單位的結(jié)果由該單元參數(shù)給出。單位的合法值與那些在TIMESTAMPADD()函數(shù)的說(shuō)明中列出相同。
mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01'); +---------------------------------------------------------+ | TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') | +---------------------------------------------------------+ | 3 | +---------------------------------------------------------+ 1 row in set (0.00 sec)