1,按时间段查询 issueDate ( 起始日期) issueTwoDate (结束日期)
if (StringUtils.isNotEmpty(issueDate) && StringUtils.isNotEmpty(issueTwoDate)){
sql.append(" and to_date(to_char(s.issueDate,'yyyy-mm-dd'),'yyyy-mm-dd') >= to_date(:issueDate,'yyyy-mm-dd') ");
params.put("issueDate", issueDate);
sql.append(" and to_date(to_char(s.issueDate,'yyyy-mm-dd'),'yyyy-mm-dd') <= to_date(:issueTwoDate,'yyyy-mm-dd') ");
params.put("issueTwoDate", issueTwoDate);
}else{
if(StringUtils.isNotEmpty(issueDate)){
sql.append(" and to_char(s.issueDate,'yyyy-mm-dd') = to_char(to_date(:issueDate,'yyyy-mm-dd'),'yyyy-mm-dd') ");
params.put("issueDate", issueDate);
}
if(StringUtils.isNotEmpty(issueTwoDate)){
sql.append(" and to_char(s.issueDate,'yyyy-mm-dd') = to_char(to_date(:issueTwoDate,'yyyy-mm-dd'),'yyyy-mm-dd') ");
params.put("issueTwoDate", issueTwoDate);
}
}