jpql中不支持java`TO_CHAR`

Question

当我运行JPQLNamedQuery时，它会给出如下错误：

Syntax error parsing [SELECT empolyee.value From Empolyee empolyee where empolyee.nameId= :value1 and empolyee.indicator='org_id' and TO_CHAR(empolyee.startDate,'YYYY-MM-DD')<= :value2 and (empolyee.endDate is null OR TO_CHAR(empolyee.endDate,'YYYY-MM-DD')>= :value3)]. The right expression is not a valid expression.

我认为错误在TO_CHAR它不受JPA的支持JPQL

Answer 1

谢谢你

OPERATOR为我工作

OPERATOR('ToChar', empolyee.startDate,'YYYY-MM-DD')<= :value1