Oracle sql日期比较（to_date）.

     粘贴主要代码出来供大家参考下。

 

  StringBuffer sqlBuffer = new StringBuffer();
  sqlBuffer.append("select * from ZHAOBIAO_SHENQING_HUIYISHI h where h.submituserid = '" + paramMap.get("id") + "'");
  if(null!=paramMap.get("beginDate")&&!paramMap.get("beginDate").isEmpty()){
   sqlBuffer.append(" and h.submitdate > to_date('" +  paramMap.get("beginDate")+ "','yyyy-MM-dd')");
  }
  if(null!= paramMap.get("endDate")&&!paramMap.get("endDate").isEmpty()){
   sqlBuffer.append(" and h.submitdate < to_date('" +  paramMap.get("endDate")+ "','yyyy-MM-dd')");
  }