MyBatis time period to query MySQL

The mapper file is written as: (fuzzy query, query time period)

                <if test= "Com_name!=null and com_name!=" ">and sc.com_name like CONCAT (CONCAT ('% ', #{com_name}), '% ') </if> <if test= "Check_begin_date!=null and check_begin_date!=" ><! [Cdata[  and Date_format (tcb.check_begin_date, '%y-%m-%d ') >=  date_format (#{check_begin_date}, '%Y-%m-% d ')]]></if><if test= "Check_end_date!=null and check_end_date!=" "><! [Cdata[  and Date_format (tcb.check_begin_date, '%y-%m-%d ') <=  date_format (#{check_end_date}, '%Y-%m-%d ') ]]></if>