查询近三个月的xml
SELECT * FROM t_order WHERE
c_pay_time >= DATE_SUB(CURRENT_DATE(),INTERVAL 3 MONTH)
查询今日的的xml
SELECT * FROM t_order WHERE
c_pay_time BETWEEN CURDATE() and DATE_ADD(CURDATE(),INTERVAL 1 DAY)
c_pay_time >= DATE_SUB(CURRENT_DATE(),INTERVAL 3 MONTH)
查询今日的的xml
SELECT * FROM t_order WHERE
c_pay_time BETWEEN CURDATE() and DATE_ADD(CURDATE(),INTERVAL 1 DAY)