日期的数据类型不匹配错误 [英] Datatype mismatch error for date

问题描述

我在ms访问中查询我需要比较日期...我需要比较的数据库字段是TRDATE（数据类型是datetime，格式是SHort Date）..当我在开发PC中运行以下查询时32位，它给我记录..

I have query in ms access where I need to compare date...My database field I need to compare is TRDATE(datatype is datetime and format is SHort Date)..When I run the below query in development PC which is 32-bit,it gives me records..

Select * from NTRANS1213 where(NTRANS1213.TRDATE  BETWEEN #3/26/2013# AND #3/26/2013#)

这两个日期都是从软件中的datetimepicker中获取的。



但如果我从上面的查询中删除＃符号，我就不会得到任何记录..

如果我使用''符号它会给我错误数据类型不匹配



当我从Office 2007的查询分析器运行64位PC时出现相同的查询，我得到了记录..

但是如果我通过应用程序运行查询，则不会恢复任何记录...

我无法弄清楚问题。请帮助我......

Both dates are taken from datetimepicker in software.

But if I remove # sign from above query,I dont get any records..
If I use '' sign it gives me error "Datatype mismatch"

The same query when I run in 64-bit PC from query analyser of Office 2007,I get records..
But If I run the query through application,no records are retrived...
I am not able to figure out the problem.Please help me....

推荐答案

1）MS A的MS JET引擎ccess数据库需要＃。

2）64位机器上的OleDb - 读它：

http://social.msdn.microsoft.com/Forums/en- US / adodotnetdataproviders / thread / d5b29496-d6a1-4ecf-b1a4-5550d80b84b6 / [ ^ ]

Jet Ole DB 4.0未注册64-bt Win 2008 [ ^ ]

http://blogs.msdn.com/b/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx [ <小时ef =http://blogs.msdn.com/b/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx\"target =_ blanktitle = 新窗口> ^ ]

1) MS JET engine for MS Access databases needs #.
2) OleDb on 64 bit machine - read it:
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6/[^]
Jet Ole DB 4.0 not registered 64-bt Win 2008[^]
http://blogs.msdn.com/b/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx[^]

这篇关于日期的数据类型不匹配错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！