oracle中获取月季年的对比

//本月
        String sqlM=" and to_char(to_date(k.createdate,'yyyy-mm-dd hh24:mi:ss'),'mm')=to_char(sysdate,'mm')";
        //本季
        String sqlJ=" and to_char(to_date(k.createdate,'yyyy-mm-dd hh24:mi:ss'),'q')=to_char(sysdate,'q')";
        String sqlYear=" and substr(k.createdate,0,4)=to_char(sysdate,'yyyy')";