and a.UPDATE_TIME >=date'2012-03-10' and a.UPDATE_TIME<=date'2012-03-31'
str = (String) map.get("checkDateEnd");
if (StringUtils.isNotBlank(str)) {
str = DateUtil.getYear(str)+"-"+ DateUtil.getMonth(str)+"-"+ DateUtil.getRiqi(str);
hql.append("and cmb.checkDate <= :endDate ");
pageQuery.setTimestamp("endDate", DateUtil.getTimestamp((str+ " 23:59:59")));
}
from cmb.crwCardApps as cr where cr.countBank.organName like '%"+str+"%')"