DATE_SUB(date,INTERVAL expr type)
if ($ischeck=='6') {
$wheresql .= " AND DATE_SUB(CURDATE(),INTERVAL 3 DAY)<=date(updatetime) ";
//exit($wheresql);
}
DATE_SUB函数可以查询当前时间以前日期的信息
SQL DATE_SUB 范例
SELECT DATE_SUB('2010-08-12', INTERVAL 3 DAY) AS NewDate
结果: 2010-08-09
2.SELECT DATE_SUB('2010-08-12', INTERVAL '3-2' YEAR_MONTH) AS NewDate
结果: 2007-06-12
3.SELECT DATE_SUB('2011-09-14 2:44:36', INTERVAL '2:26' HOUR_MINUTE) AS NewDate
结果: 2011-09-14 00:18:36