SQL 日期格式绑定变量

Question

谁能告诉我这个 SQL 查询有什么问题吗？

select 
    USERNAME, DATECREATED, CREDTYPE, USAGETYPE,  OPERATIONID, TXNID, CALLERID 
from 
    arwfissuanceauditlog 
where 
    OPERATIONID in (2104,2107) 
and datecreated >= 'to_date('2010/06/21', 'yyyy/MM/dd HH24:MI:SS')' 
and datecreated < 'to_date('2010/08/03', 'yyyy/MM/dd HH24:MI:SS')'

当我在 SQL Developer 中运行它时，我收到此消息

Unknown Command
Bind Variable "MI" is NOT DECLARED

，我从 java 中调用此消息，如下所示

try {
            stmt = conn.createStatement();
            results = stmt.executeQuery(queryToExecute);
        } catch (SQLException e) {
            CredChangeReportSVC.DEFAULTLOGGER.error("An exception occurred while executing query: " + queryToExecute, e);
}

在日志中，我收到此消息

ERROR 03 Aug 2010 14:51:06,939 - An exception occurred while executing query: "select USERNAME, DATECREATED, CREDTYPE, USAGETYPE,  OPERATIONID, TXNID, CALLERID from arwfissuanceauditlog where OPERATIONID in (2104,2107) and datecreated >= 'to_date('2010/06/21', 'yyyy/MM/dd HH24:MI:SS')' and datecreated < 'to_date('2010/08/03', 'yyyy/MM/dd HH24:MI:SS')'"
java.sql.SQLException: Invalid SQL type

提前致谢。

Answer 1

您的日期格式指定了时间部分，但您在日期时间字符串中省略了它。从日期字符串中删除“HH24:MI:SS”，然后重试