按时间查询数据库

[cocosgirl]

//当天
SELECT * FROM tb_agent_recharge_records WHERE tradeType=1 AND DATE(tradingTime) = CURDATE()
//昨天
SELECT * FROM tb_agent_recharge_records WHERE DATE(tradingTime) = CURDATE()-1
//
SELECT * FROM tb_agent_recharge_records WHERE YEARWEEK(DATE_FORMAT(tradingTime,'%Y-%m-%d')) = YEARWEEK(NOW())
//
SELECT * FROM tb_agent_recharge_records WHERE YEARWEEK(DATE_FORMAT(tradingTime,'%Y-%m-%d')) = YEARWEEK(NOW())-1
//
SELECT * FROM tb_agent_recharge_records WHERE DATE_FORMAT(tradingTime,'%Y-%m')=DATE_FORMAT(NOW(),'%Y-%m')
//
SELECT * FROM tb_agent_recharge_records WHERE DATE_FORMAT(tradingTime,'%Y-%m')=DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 1 MONTH),'%Y-%m')

[不吃西红柿炒鸡蛋]

？？？？？？？？？？？？？