oracle中日期的模糊查询 oracle日期模糊查询

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

}

}