mysql中sql转换成hibernate中hql文的问题

[kukoukele]

List<Clerk> birthdayClerkList = null;
try{
String hql = "from Clerk cle where DATE_FORMAT(cle.birthday,'%m%d') >= " +
"DATE_FORMAT(NOW() ,'%m%d') and DATE_FORMAT(cle.birthday,'%m%d')" +
" <= DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) ,'%m%d')";
//Query query = getSession().createSQLQuery(hql,"cle",Clerk.class);
Query query = getSession().createSQLQuery(hql);
//Query query = getSession().createQuery(hql);
birthdayClerkList = query.list();
//birthdayClerkList = this.find(hql);
}catch (DataAccessException e) {
log.error("Error in getAllBirthdayClerkList.", e);
throw new DaoException("Error in getAllBirthdayClerkList.", e);
}
=============================================================
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 7 near line 1, column 187 [from com.foundersoftware.ehr.object.hr.Clerk cle where DATE_FORMAT(birthday,'%m%d') >= DATE_FORMAT(NOW() ,'%m%d') and DATE_FORMAT(birthday,'%m%d') <= DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) ,'%m%d')]; nested exception is org.hibernate.hql.ast.QuerySyntaxError: unexpected token: 7 near line 1
报错的大概意思是语法错误
这个问题出在哪?是不是mysql中sql转换成hibernate中hql文的问题,特别是DATE_FORMAT在hibernate中不可使用?

[kokobox]

感觉还是lz的hql拼装错误

[IamHades]

语法错误撒，应该是这里：
DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) , '%m%d ')
你自己检查下吧，mysql不熟，所以不知道为什么错

[haoxiongok]

帮楼主顶上去

[code_JAVA]

DATE_FORMAT()的返回类型是啥,不是格式化成字符串吧,那就不能比较了,oracle中会用到to_date(),mysql不大清楚

[mush_me]

跟随楼主的脚印来到此处，却得到无解。

[goodsun00]

日期 可以用<= >=比较？