使用SQL对日期模糊查询
SELECT * FROM T_CALENDAR t WHERE(to_char(t.CURDATE,'yyyy-MM-dd hh24:mi:ss') LIKE '%2017%')
使用HQL对日期模糊查询
String year="2017";
String month="05";
List<MyCalendar> list = myDao.find("FROM MyCalendar obj WHERE to_char(obj.curDate,'yyyy-MM-dd hh24:mi:ss') like ?","%"+year+"-"+month+"%");