filter中的日期字段

tlkj

dispData.setFilter("jbsjFil", "substring(jbsj,0,9) = DateToString(:currentDate())");
报错：
Caused by: java.sql.SQLException: 参数数据类型 datetime 对于 substring 函数的参数 1 无效。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 32 more

jishuang

这个应该是sqlserver数据库的语法不一样

data.setFilter("filter1", "substring(dateTimeToString(AP_RQ.fRQSJ),0,9) = DateToString(:currentDate())");