数据库中: select * from dj_log where 1=1 and to_char(log_date,‘yyyy-MM-dd‘) like ‘%2005-10-18%‘
java类中,hibernate中的查询语句即hql语句
StringBuffer sb = new StringBuffer(); sb.append("from OpLog as oplog where 1=1"); if (!"".equals(StringUtil.display(logDate))) { sb.append(" and to_char(oplog.logDate,‘yyyy-MM-dd‘) like ‘%").append( logDate.substring(0,10)).append("%‘"); }