mybatis的xml日期范围查询

 <if test="param.startTime != null and param.startTime != '' and param.endTime != null and param.endTime != ''">

     <![CDATA[  and DATE_FORMAT(p.create_time, '%Y-%m-%d %H:%T:%s') >
                    DATE_FORMAT(#{param.startTime} , '%Y-%m-%d %H:%T:%s')    ]]>

      <![CDATA[  and DATE_FORMAT(p.create_time, '%Y-%m-%d %H:%T:%s') <=
                     DATE_FORMAT(#{param.endTime} , '%Y-%m-%d %H:%T:%s')    ]]>
</if>