Hi All,
I am executing a select query which involve join between three tables through jdbc. I am using MS-ACCESS as database.
This query needs to get the data based on some conditions on date fields.
While executing the query I am getting [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
I found where the problem is but i don't know how to solve.
Problem is in date format.
where TT.ARRIVED between '2007-07-01 00:00:00' and '2007-07-30 00:00:00'
In the above part of the query ARRIVED is a DATE/TIME type field in MS-ACCESS and its format is General Date.
Please tell me how to give this format from java.
Thanks in advance.