I'm trying to retrieve data from an ACCESS database. I have an sql statement that looks like
String query = "select * from AuditTrail where CAST(LOGDATE AS DATE) = current_date";
I get the following error
sqlstate 37000
detailMessage= "[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'cast(logdate as Date)'."
Can someone tell me what i'm doing wrong please?