前台时间 String 类型格式化为了 “yyyy-mm”，
hql 语句 。 数据库Oracle ，createUserTime字段为timestamp类型的。Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: to_char near line 1, column 555 [select distinct gprs.id as id,gprs.orgId as orgId,gprs.orgName as orgName,gprs.simNo as simNo,gprs.costName as costName,gprs.cost as cost,gprs.createUserId as createUserId, gprs.createUserName as createUserName, gprs.createUserTime as createUserTime,gprs.lastUpdateTime as lastUpdateTime,gprs.lastUpdateId as lastUpdateId,gprs.updateUserName as updateUserName,gprs.remark as remark from cn.com.yto56.coresystem.module.logic.pdabasic.domain.Gprs gprs, cn.com.yto56.coresystem.module.logic.pdabasic.domain.PdaOrgInfo orgifo where gprs.orgId=orgifo.codeand to_char(gprs.CREATE_USER_TIME,'YYYY-MM')=to_char(2014-06,'YYYY-MM') and orgifo.code=? order by gprs.lastUpdateTime desc]
数据库不认识，请教各位应该怎么弄。
------解决方案--------------------
传当月月初和月尾两天 进行 between 这样也是可以实现的吧
------解决方案--------------------
oracle 的to_char函数貌似不能够格式化string类型的值吧，可以先在代码中用SimpleDateFormat将time先格式成想要的字符串格式。