查询本周数据sql

<!-- 查询本周数据-->
    <select id="selectDtWeek" resultType="Dt">
        SELECT * FROM `dating` 
        WHERE 
        YEARWEEK(date_format(zbdate,'%Y-%m-%d'),1) = YEARWEEK(now(),1)
    </select>
复制