SELECT DATE_FORMAT(a.`time`,'%Y-%m-%d')FROM `table a WHERE 1=1 AND
CONVERT(a.`time`,DATE) !=CONVERT(NOW(),DATE)
NOW()替换某一天
SELECT DATE_FORMAT(a.`time`,'%Y-%m-%d')FROM `table a WHERE 1=1 AND
CONVERT(a.`time`,DATE) !=CONVERT(NOW(),DATE)
NOW()替换某一天