Query getDistributionSchedulesByDate = entityManager.createNamedQuery("getDistributionSchedulesByDate");
getDistributionSchedulesByDate.setParameter("upperBoundDate", DateUtils.getUpperBoundDate(date));
List<DistributionSchedule> resultList = (List<DistributionSchedule>
getDistributionSchedulesByDate.getResultList();
**********************************
And DateUtils.getUpperBoundDate(date) method implementation is like::
public static Calendar getUpperBoundDate(Calendar date) {
Calendar upperBoundDate = Calendar.getInstance();
upperBoundDate.setTime(date.getTime());
upperBoundDate.set(Calendar.HOUR_OF_DAY, 23);
upperBoundDate.set(Calendar.MINUTE, 59);
upperBoundDate.set(Calendar.SECOND, 59);
System.out.println(upperBoundDate.getTime());
return upperBoundDate;
}
[ November 06, 2008: Message edited by: Rahul Ba ]