PHP中csv导出三个月内的数据

回复讨论(解决方案)

select * fromtbl_namewhere date >= date_format(subdate(now(), INTERVAL 3 month), '%Y-%m-%d')
或
select * fromtbl_namewhere date >= date_format(subdate(now(), INTERVAL 3 month), '%Y-%m-01')

select * fromtbl_namewhere date >= date_format(subdate(now(), INTERVAL 3 month), '%Y-%m-%d')
或
select * fromtbl_namewhere date >= date_format(subdate(now(), INTERVAL 3 month), '%Y-%m-01')

select * fromtbl_namewhere date >= date_format(subdate(now(), INTERVAL 3 month), '%Y-%m-%d')
或
select * fromtbl_namewhere date >= date_format(subdate(now(), INTERVAL 3 month), '%Y-%m-01')

date("Y-m",strtotime("-3 month"))."-01"; 三个月前的第一天

你都有算法了 三个月的不会么？ 照葫芦画瓢整呗