sql:
select to_char(SYSDATE - interval '1' day,'yyyyMMdd') from dual
错误信息:
Caused by: java.lang.IllegalArgumentException: No enum constant
com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.day
druid版本:
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.29</version>
</dependency>
解决办法:
day改为大写
select to_char(SYSDATE - interval '1' DAY,'yyyyMMdd') from dual
这里是低版本druid的bug