java 报错

MENG1

SQL.convert(varchar(10),b.activationdate,120)=SQL.convert(varchar(10),SQL.getdate(),120)

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154020; 提示: 不支持KSQL函数VARCHAR
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.fun.FunctionManager.getFunction(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.LocalSqlFunctionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
... 35 more

jishuang

已经提示了啊:不支持KSQL函数VARCHAR
用SQL.调用数据库函数

zhang0118

jishuang 发表于 2021-4-1 11:39
已经提示了啊:不支持KSQL函数VARCHAR
用SQL.调用数据库函数

结帖，谢谢