to_date
SELECT t1.* FROM xj_repair t1
<if test="null != zxcjsj and zxcjsj != ''">
and to_date(create_time::text,'YYYY-MM-DD') >= to_timestamp(#{zxcjsj},'YYYY-MM-DD')
</if>
to_char
SELECT t1.* FROM xj_repair t1
<if test="null != zxcjsj and zxcjsj != ''">
AND to_char(t1.create_time, 'yyyy-MM-dd') = #{zxcjsj}
</if>