日期:2014-05-16  浏览次数:20678 次

mysql中sql语句比较两日期天数差
SELECT *,DATEDIFF(NOW(),SEND_TIME) FROM MB_T_MESSAGE WHERE IS_VALID='1' AND DATEDIFF(NOW(),SEND_TIME)<10
?

?