admin
MySQL数据库查询中有直接的时间限制使用DATEDIFF函数可以直接限制时间
SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate
结果是1
SELECT DATEDIFF(day,'2008-12-30','2008-12-29') AS DiffDate
结果是-1