你是什么数据库?
sql server 数据库:
SELECT *
FROM 表1
where 1=1
${if(len(outdate) == 0,"","and CONVERT ( VARCHAR ( 10 ), F_OutDate, 120 ) like '" + outdate +"%'")}
${if(len(customername) == 0,"","and F_CustomerName = '" + customername + "'")}
-----------oracel数据库------------------
SELECT *
FROM 表1
where 1=1
${if(len(outdate) == 0,"","and to_char(F_OutDate, 'yyyy-mm-dd' ) like '" + outdate +"%'")}
${if(len(customername) == 0,"","and F_CustomerName = '" + customername + "'")}
-------mysql数据库---------------
SELECT *
FROM 表1
where 1=1
${if(len(outdate) == 0,"","and DATE_FORMAT(F_OutDate, '%Y-%m-%d' ) like '" + outdate +"%'")}
${if(len(customername) == 0,"","and F_CustomerName = '" + customername + "'")}