在Oracle中查询日期类型也是将日期类型转换为字符类型:
数据库中
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("%'");
}
数据库中
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("%'");
}