[quote]
根据日期查
select * from fm_account_recharge where date_format(pay_finish_time, '%Y-%m-%d') = date_format('2018-02-24','%Y-%m-%d')
DATE_SUB(NOW(),INTERVAL 5 MINUTE)
DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S')
查询本周数据
select * from 数据表 where YEARWEEK(DATE_FORMAT(时间字段名,'%Y-%m-%d')) = YEARWEEK(NOW())
select * from 数据表 where 时间字段名 BETWEEN '2016-02-01' AND '2016-02-05'
select * from 数据表 where 时间字段名 BETWEEN DATE_SUB(NOW(),INTERVAL 3 MONTH) AND NOW()
http://blog.csdn.net/zhaitonghui/article/details/53080992
[/quote]
根据日期查
select * from fm_account_recharge where date_format(pay_finish_time, '%Y-%m-%d') = date_format('2018-02-24','%Y-%m-%d')
DATE_SUB(NOW(),INTERVAL 5 MINUTE)
DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S')
查询本周数据
select * from 数据表 where YEARWEEK(DATE_FORMAT(时间字段名,'%Y-%m-%d')) = YEARWEEK(NOW())
select * from 数据表 where 时间字段名 BETWEEN '2016-02-01' AND '2016-02-05'
select * from 数据表 where 时间字段名 BETWEEN DATE_SUB(NOW(),INTERVAL 3 MONTH) AND NOW()
http://blog.csdn.net/zhaitonghui/article/details/53080992
[/quote]