var t2 =FR.remoteEvaluate('=sql("DM","SELECT count(FID) from CT_RUBBISH_INFO where to_char(CREATETIME,'yyyy-MM-dd') =to_char(SYSDATE,'yyyy-MM-dd') AND FNAME=\''+a+'\'",1,1)'); 有个日期的转换该怎么修改,报错如下
var t2 =FR.remoteEvaluate('=sql("DM","SELECT count(FID) from CT_RUBBISH_INFO where to_char(CREATETIME,\'yyyy-MM-dd\') =to_char(SYSDATE,\'yyyy-MM-dd\') AND FNAME=\''+a+'\'",1,1)');
var t2 = FR.remoteEvaluate("=sql('DM','SELECT count(FID) from CT_RUBBISH_INFO where to_char(CREATETIME,'yyyy-MM-dd') =to_char(SYSDATE,'yyyy-vMM-dd') AND FNAME='" + a + "',1,1)");