0 0

hql语句、 怎么改 急谢谢0

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 10 near line 1, column 111 [from com.scihi.cms.entity.main.Order where orderStatus = 2 and TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now())>0]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 10 near line 1, column 111 [from com.scihi.cms.entity.main.Order where orderStatus = 2 and TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now())>0]



from com.scihi.cms.entity.main.Order where orderStatus = 2 and TIMESTAMPDIFF(SECOND,DATE_ADD(buyDate,INTERVAL 10 DAY_MINUTE),now())>0



hql语句不支持吗? 怎么修改

问题补充:应该是 INTERVAL 10 DAY_MINUTE 这句话有问题,请问怎么修改? 谢谢
2014年9月03日 13:42
目前还没有答案

相关推荐

Global site tag (gtag.js) - Google Analytics