时间比较的hql(不带时分秒时): begindate>=TO_DATE('2009-08-04','YYYY-MM-DD') and enddate<=('2009-08-11 23:59:59','YYYY-MM-DD HH24:MI:SS')