Я пытаюсь запросить данные из HSQLDB 2.2.8 с помощью Spring JDBC 3.1.2.RELEASE, вот утверждение:
"SELECT id, account_id, operator_id, amount, currency_type, date
FROM account_entries WHERE account_id=? AND date BETWEEN DATE '?' AND DATE '?' + 1 DAY"
Свойства:
1 (java.lang.Integer)
2012-09-06 (java.sql.Date)
2012-09-06 (java.sql.Date)
Ошибка, которую я получаю:
PreparedStatementCallback; SQL [SELECT id, account_id, operator_id, amount,
currency_type, date FROM account_entries WHERE account_id=?
AND date BETWEEN DATE '?' AND DATE '?' + 1 DAY]; data exception:
invalid datetime format; nested exception is java.sql.SQLDataException:
data exception: invalid datetime format