简要说明:
这个是mysql数据库的语句:SELECT * FROM tbl_zfxx WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 5
也就是查询前5天的记录。date是字段列名但是在hibernate 的HQL语句又该怎么写?
请指教!
这个是mysql数据库的语句:SELECT * FROM tbl_zfxx WHERE TO_DAYS(NOW()) - TO_DAYS(date) <= 5
也就是查询前5天的记录。date是字段列名但是在hibernate 的HQL语句又该怎么写?
请指教!
public Date getDiffDay(int diff){
Calendar cstart = Calendar.getInstance();
/** cstart.set(Calendar.MINUTE, 0);//取整点比较
cstart.set(Calendar.SECOND, 0);
cstart.set(Calendar.MILLISECOND, 0);
**/
cstart.set(Calendar.DAY_OF_YEAR, cstart
.get(Calendar.DAY_OF_YEAR)-diff );
return cstart.getTime();}HQL =" FROM tbl_zfxx WHERE date>="+getDiffDay(5);