| Author |
cast a date from an access date/time field
|
Mikealan Smith
Greenhorn
Joined: Aug 29, 2003
Posts: 15
|
|
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?
|
 |
 |
|
|
subject: cast a date from an access date/time field
|
|
|
0
