sql解析，日期 trunc sysdate

SELECT jh rpc,hs rhs,(SELECT SUM(jh) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'MM')  -- 本月第一天
        AND rq < TRUNC(SYSDATE) AND dwdm = #{dwdm} ) ypc,
        (SELECT SUM(hs) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'MM')  -- 本月第一天
        AND rq < TRUNC(SYSDATE) AND dwdm = #{dwdm} ) yhs,
        (SELECT avg(njh) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'YYYY')  -- 本年第一天
        AND rq < TRUNC(SYSDATE) AND dwdm = #{dwdm} ) npc,
        (SELECT SUM(hs) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'YYYY')  -- 本年第一天
        AND rq < TRUNC(SYSDATE) AND dwdm = #{dwdm} ) nhs,
        nsy,nlhs - nsy AS ncz,jh - hs AS ycz FROM  aqks.aa_scyj WHERE rq = to_date(#{rq},'yyyy-MM-dd') AND dwdm = #{dwdm}

TRUNC(SYSDATE, 'MM') ：

 rq传递过来的是字符串，要是有to_data转换为时间类型