HQL 查询的时间问题

   public List getSeatClassSortedByDiscountAndPublishDate() {
        Object[] parameters = new Object[2];
        parameters[0] = new Integer(SeatClassConstants.SEATCLASS_STATUS_ABLE);
        parameters[1] = new Date();
        return super.find(
                "from SeatClass as c where  c.status=? and c.expirationDate>=?  order by c.discount desc,c.id desc ",
                parameters);
    }

 parameters[1] = new Date();的new Date()带有时间如果数据库中没有带时间，需要把new Date()的时间去掉

    public static Date clearHHmmss(Date date) {
        Calendar cal = Calendar.getInstance();
        cal.setTime(date);
        cal.set(Calendar.HOUR_OF_DAY, 0);
        cal.set(Calendar.MINUTE, 0);
        cal.set(Calendar.SECOND, 0);
        return cal.getTime();
    }