470,612 Members | 2,246 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,612 developers. It's quick & easy.

Date format problem in MS-ACCESS

2
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.
Jun 25 '07 #1
1 2965
r035198x
13,262 8TB
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.
If you are prividing the Date from a Java program use java.sql.Date.
Jun 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

15 posts views Thread by Simon Brooke | last post: by
1 post views Thread by Keith Chadwick | last post: by
5 posts views Thread by Hai Nguyen | last post: by
3 posts views Thread by Herryandi | last post: by
7 posts views Thread by Fred Flintstone | last post: by
26 posts views Thread by jshanman | last post: by
27 posts views Thread by RobG | last post: by
8 posts views Thread by yashiro | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.