关于在Hibernate里面用convert函数把对象里面的数据转化为另一个数据类型

1.Convert转成String,在用Like查询。
select * from table1   where convert(varchar,date,120) like   '2006-04-01%' 

我在项目中要用到like查询日期时间我接收到的参数时String类型数据库里面的日期字段类型为datetime的

@RequestMapping(params = "getSelectDatagrid")
	public void getSelectDatagrid(HttpServletRequest request,HttpServletResponse response){
		JsonResult jr = new JsonResult();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		try{
			String name = request.getParameter("selectName");
			String technicalGrade = request.getParameter("selectTechnicalGrade");
			String birthdayDate = request.getParameter("selectBirthdayDate");
			String joinWorkDate = request.getParameter("selectJoinWorkDate");
			String hql = "FROM ExportInfoEntity WHERE 1=1" ;
			if(StringUtil.isNotEmpty(name)){
				hql += " AND name LIKE '%" + name + "%'";
			}
			if(StringUtil.isNotEmpty(technicalGrade)&& !technicalGrade.equals("0")){
				hql += " AND technicalGrade LIKE '%" + technicalGrade + "%'";
			}
			if(StringUtil.isNotEmpty(birthdayDate)){
				hql += " AND convert(varchar,birthdayDate,120) LIKE '%" + birthdayDate + "%'";
			}
			if(StringUtil.isNotEmpty(joinWorkDate)){
				hql += " AND convert(varchar,joinWorkDate,120) LIKE '%" + joinWorkDate + "%'";
			}			
			List<ExportInfoEntity> list = systemService.findByQueryString(hql);
			if(list.size()>0 && list!=null){
				for(ExportInfoEntity exportInfoEntity : list){
					if(oConvertUtils.isNotEmpty(exportInfoEntity)){
						if(exportInfoEntity.getTechnicalGrade()==1){
							exportInfoEntity.setStrTechnicalGrade("一般");
							
						}else if(exportInfoEntity.getTechnicalGrade()==2){
							exportInfoEntity.setStrTechnicalGrade("良好");
							
						}else if(exportInfoEntity.getTechnicalGrade()==3){
							exportInfoEntity.setStrTechnicalGrade("优秀");
							
						}
					}
				}
				
			}
			jr.setResultCode(0);
			jr.setResultObject(list);
		}catch(Exception e){
			e.printStackTrace();
		}
		this.flushObjectJson(jr, response);
	}