if(StringUtils.isNotEmpty(_startDate)&& StringUtils.isNotEmpty(_endDate)){ sql.append(" AND " + columnName + " >= to_date('" + _startDate + "','yyyy-MM-dd') and " + columnName + " <= to_date('" + _endDate + "','yyyy-MM-dd')"); }
?
if(StringUtils.isNotEmpty(_startDate)&& StringUtils.isNotEmpty(_endDate)){ sql.append(" AND " + columnName + " >= to_date('" + _startDate + "','yyyy-MM-dd') and " + columnName + " <= to_date('" + _endDate + "','yyyy-MM-dd')"); }
?