filter的时间过滤问题
ls_filter=ls_filter+" and to_Date(h.enddate,'yyyymmdd h24:mi:ss')>=to_date(sysdate,'yyyymmdd h24:mi:ss')" 运行的时候提示: ')'expected to close expression afer function 但是好像不缺右括号啊------解决方案-------------------------------------------------------- ls_filter=ls_filter+" and string(h.enddate,'yyyymmdd h24:mi:ss')>=string(sysdate,'yyyymmdd h24:mi:ss')" 用setfilter过滤时间我一般都是这样过滤的: ls_filter = "string(h.enddate,'yyyymmdd h24:mi:ss') >= '"+string(sysdate,'yyyymmdd h24:mi:ss')+"'" dw_1.setfilter(ls_filter) dw_1.filter()