MySql:
if(!StringUtil.isEmpty(dateStart)){
Date date = (Date)params.get("dateStart");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
dateStart = sdf.format(date);
sb.append(" AND FINAL.creation_date >= '"+dateStart+"'");
}
if(!StringUtil.isEmpty(dateEnd)){
Date date = (Date)params.get("dateEnd");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd 23:59:59");
dateEnd = sdf.format(date);
sb.append(" AND FINAL.creation_date <= '"+dateEnd+"'");
}
Oracle:
if(!StringUtil.isEmpty(dateStart)){
Date date = (Date)params.get("dataStart");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
dataStart= sdf.format(date);
sb.append(" AND FINAL.APPROVE_DATE <= to_date('"+dataStart+"','yyyy-mm-dd hh24:mi:ss')");
}
if(!StringUtil.isEmpty(dataEnd)){
Date date = (Date)params.get("dataEnd");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd 23:59:59");
dataEnd= sdf.format(date);
sb.append(" AND FINAL.APPROVE_DATE <= to_date('"+dataEnd+"','yyyy-mm-dd hh24:mi:ss')");
}