hql 查询当天记录

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';