SELECT check_type,user_check_time,week(user_check_time),year(user_check_time)FROM attendance WHERE week(user_check_time)=30andyear(user_check_time)=2019;
查询某季的数据
SELECT check_type,user_check_time,quarter(user_check_time),year(user_check_time)FROM attendance WHERE quarter(user_check_time)=4andyear(user_check_time)=2019;