fbsj:varcher-<date-<datetime 再判断
近一周:
select * from financial_regulations where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(STR_TO_DATE(fbsj, '%Y-%m-%d %H:%i:%s'))
近一个月:
select * from financial_regulations where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= date(STR_TO_DATE(fbsj, '%Y-%m-%d %H:%i:%s'))
近一年:
select * from financial_regulations where DATE_SUB(CURDATE(), INTERVAL 1 YEAR) <= date(STR_TO_DATE(fbsj, '%Y-%m-%d %H:%i:%s'))