61,129
社区成员
发帖
与我相关
我的任务
分享按时间查询数据库
//当天
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')
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')
...全文
请发表友善的回复…
发表回复
不吃西红柿炒鸡蛋 2016-08-01
- 打赏
- 举报
？？？？？？？？？？？？？
