MySQL关于日期的查询sql-Flyfish
---查询今天的记录SELECT * FROM wmacc.`cash_trade_record` WHERETO_DAYS(create_date) = TO_DAYS(NOW());
SELECT * FROM wmacc.`cash_trade_record` WHEREDATE_FORMAT(create_date, '%Y%m%d') = DATE_FORMAT(CURDATE(), '%Y%m%d');
---查询昨天的记录
SELECT * FROM wmacc.`cash_trade_record` WHERETO_DAYS(create_date) = TO_DAYS(NOW()) - 1;
---查询最近7天的记录
SELECT * FROM wmacc.`cash_trade_record` WHERE DATE_SUB(NOW(), INTERVAL 7 DAY)
页:
[1]