${if(len(startDelivyTime) == 0,"","and W51.DELIVY_TIME >= '" + to_char(to_date(startDelivyTime,'yyyy-MM-dd HH24:mi:ss'),'yyyyMMddHHmmss') + "'")}
时间参数的如何转换
${if(len(startDelivyTime) == 0,"","and W51.DELIVY_TIME >= to_char(to_date("+startDelivyTime+",'yyyy-MM-dd HH24:mi:ss'),'yyyyMMddHHmmss')")}
${if(len(startDelivyTime) == 0,"","and W51.DELIVY_TIME >= to_char(to_date('" + startDelivyTime + "','yyyy-MM-dd HH24:mi:ss'),'yyyyMMddHHmmss')")}
-------------
其实可以用帆软的FORMAT()替换
${if(len(startDelivyTime) == 0,"","and W51.DELIVY_TIME >= '"+ FORMAT(startDelivyTime,"yyyyMMddHHmmss") + "'")}
${if(len(startDelivyTime) == 0,"","and W51.DELIVY_TIME >= to_char(to_date('" + startDelivyTime+"','yyyy-MM-dd HH24:mi:ss'),'yyyyMMddHHmmss') ")}
可以参考：https://help.fanruan.com/finereport10.0/doc-view-2394.html?source=4#
1min目标场景问卷
立即参与
