java - ORA-01858 : a non-numeric character was found where a numeric was expected in Oracle ADF

Question

为什么我会通过 Java 应用程序执行此查询从 Oracle 收到上述 SQL 错误？

SELECT * FROM TestSchema.TestTable
WHERE userid = :userId
AND transactionDate BETWEEN TO_DATE(:start_date, 'yyyy-mm-dd')
AND TO_DATE(:end_date,'yyyy-mm-dd')

Answer 1

我明白了。在此示例中，start_date 和 end_date 不需要 to_date 函数。这工作得很好:

SELECT * FROM TestSchema.TestTable
WHERE userid = :userId
AND transactionDate BETWEEN :start_date AND :end_date