hql 查询当天记录

public List<DAReserve> getDeviceReserveById(Date date,Long deviceId) {
        // TODO Auto-generated method stub
        Query query = entityMgr.createQuery(" from DAReserve da where da.deviceId = ? and da.status in (?,?) and date(da.startTime) = ? ");
        
        query.setParameter(1,deviceId);
        query.setParameter(2,"0");
        query.setParameter(3,"1");
        query.setParameter(4,date);
        return query.getResultList();
    }

引用

生成 的sql

select dareserve0_.id 
as id10_, dareserve0_.DEVICE_ID 
as DEVICE2_10_, dareserve0_.END_TIME
 as END3_10_, dareserve0_.PERMIT_CODE
  as PERMIT4_10_, dareserve0_.remark as
   remark10_, dareserve0_.START_TIME as START6_10_, 
   dareserve0_.status as status10_,
   dareserve0_.USER_ID as USER8_10_ from mctsdb.da_reserve dareserve0_ where dareserve0_.DEVICE_ID=1 
and (dareserve0_.status in ('0' , '1')) and date(dareserve0_.START_TIME)='2011-11-08';