Actually I am using java.sql.Date cast to java.util.Date in the Calendar setTime() method and java.util.Calendar. Here is a sample of my code.
Calendar compareDate = Calendar.getInstance();
Calendar recordDate = Calendar.getInstance();
compareDate.add(Calendar.DATE, -7);
compareDate.set(Calendar.MILLISECOND, 0);
compareDate.set(Calendar.SECOND, 0);
compareDate.set(Calendar.MINUTE, 0);
compareDate.set(Calendar.HOUR, 0);
while(resultSet.next())
{
recordDate.setTime(resultSet.getDate("dbRecordDate"));
recordDate.set(Calendar.MILLISECOND, 0);
recordDate.set(Calendar.SECOND, 0);
recordDate.set(Calendar.MINUTE, 0);
recordDate.set(Calendar.HOUR, 0);
if(recordDate.after(compareDate))
{
// This seems to work
}
if(recordDate.equals(compareDate))
{
// This does not work
}
if(recordDate.before(compareDate))
{
// This seems to work
}
}
This code is very awkward. I need a simple way of compareing a date in a db record to another date. The date 01-05-03 15:20:59 should equal the date 01-05-03 04:45:03
Thanks,
Warren Bell
warren@clarksnutrition.com