#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;

SELECT date(%1 + 1721424.5,'start of month');

UPDATE Objects
SET
  Name = '%2',
  Address = '%3',
  Type = '%4',
  Direct = '%5',
  Period = %6,
  Previouse = %7, Вот сюда надо целое без округления SELECT date(%1 + 1721424.5,'start of month')
  Next = %8,
  Monitoring = %9,
  Importance = %10
WHERE
  Id = %1

#pas
SELECT date(%7 + 1721424.5,'start of month') --будет быстрее

#pas
UPDATE Objects
SET
  Name = '%2',
  Address = '%3',
  Type = '%4',
  Direct = '%5',
  Period = %6,
  Previouse = (SELECT date(%7 + 1721424.5,'start of month')+0),
  Next = %8,
  Monitoring = %9,
  Importance = %10
WHERE
  Id = %1

  Previouse = (SELECT date(%7 + 1721424.5,'start of month') + 0),

SELECT strftime('%J', date(%7 + 1721424.5,'start of month')) - 1721424.5

#cpp
Query result = session.createQuery(query.toString());

#cpp
            List<History> list = getSession().createCriteria(History.class)
                    .addOrder(Order.desc("id")).setMaxResults(50).list();