sql查询本周、本月数据

本周数据从周一开始

SELECT
    *
FROM
    `tend_scheduling_item`
WHERE
    tend_psn_hid = 498
AND YEARWEEK(date_format(duty_date, '%Y-%m-%d'),1
) = YEARWEEK(now(),7);

本周数据从周日kai'开始

SELECT
    *
FROM
    `tend_scheduling_item`
WHERE
    tend_psn_hid = 498
AND YEARWEEK(date_format(duty_date, '%Y-%m-%d')
) = YEARWEEK(now());