#pas
SELECT * FROM таблица WHERE Date BETWEEN StartDate AND EndDate ORDER BY Date; 

#cpp
if(startDate!=null){
if(isFirst){
query.append(" where date >=  + sdf.format(startDate) + ");
}else{
query.append(" and date >=  + sdf.format(startDate) + ");
}
isFirst = false;
   }
 
   if(endDate!=null){
if(isFirst){
query.append(" where date <=  + sdf.format(endDate) + ");
}else{
query.append(" and date <=  + sdf.format(endDate) + ");
}
isFirst = false;
   }
 
   if(volume!=null){
if(isFirst){
query.append(" where volume >= " + volume);
}else{
query.append(" and volume >= " + volume);
}
isFirst = false;
   }
 
   query.append(" order by date");
   Query result = session.createQuery(query.toString());
 
   return result.list();
}

#pas
SELECT * FROM таблица WHERE Date > StartDate AND Date < EndDate ORDER BY Date;