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
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?
subject: cast a date from an access date/time field