自定义sql报表预览报错

[适用版本]

8.6sp11

[解决方案]

问题:

用to_char(ATS_RESULT.S1,'yyyy-mm-dd hh24:mi:ss') AS ATS_RESULT.S1 转换日期格式后,数据预览报错,apusic日志如下:

2021-06-16 10:39:20 错误 [con.err-Thread 319] com.kingdee.shr.rpts.ctrlsqldesign.exception.CtrlReportException: 解析SQL语句失败,请检查是否符合KSQL语法unsupport sql text

2021-06-16 10:39:20 错误 [con.err-Thread 319] at com.kingdee.shr.rpts.ctrlsqldesign.exception.CtrlReportException.makeException(CtrlReportException.java:56)

2021-06-16 10:39:20 错误 [con.err-Thread 319] at com.kingdee.shr.rpts.ctrlsqldesign.model.CtrlDesignDataExecutor.buildModelSQL(CtrlDes