按表中日期查询信息怎么查?
表中signTime字段的值为
2008-10-10 00:00:00
2008-10-10 01:00:00
在页面中按时间查询信息
我的sql是 "from Contract c where c.signTime = to_date('" + crmContract.getSignTime() + "','yyyy-mm-dd hh24:mm:ss'";
hibernate 执行时 sql为 from com.cyc.services.crm.domaindata.CrmContract c where c.signTime = to_date('Fri Oct 10 00:00:00 CST 2008','yyyy-mm-dd hh24:mm:ss'
报错 expecting CLOSE, found 'null'