mysql查詢本周、月、季度、年，mysql季度

mysql查詢本周、月、季度、年，mysql季度

#查詢本周記錄

select * from product_process where WEEKOFYEAR(update_time)=WEEKOFYEAR(now()); 

#查詢本月數據 

select * from product_process where MONTH(update_time)=MONTH(NOW()) and year(update_time)=year(now()); 

#查詢本季度數據
select * from product_process where QUARTER(update_time)=QUARTER(now());

#查詢本年數據
select * from product_process where YEAR(update_time)=YEAR(NOW());