dbf数据库如何查询日期类型的字段？

[telankes2000]

操作系统：wind7 64 sp1
链接驱动:    string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + dataSource + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
用以下查询语句均出现错误: 
"select * from tb  where [DATETIME] > '2014-07-01 00:00:00'" 

"select * from tb  where [DATETIME] >CTOT( '2014-07-01T00:00:00)'" 
 ERROR [22018] [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch.

[q107770540]

参数化查询语句试试： http://stackoverflow.com/questions/16645462/c-sharp-insert-datetime-to-dbf-file http://bbs.csdn.net/topics/80313725

[Peng_baoqing]

Dim datetime As date
datetime = Cdate(Format("2014-07-01 00:00:00", "yyyy-mm-dd HH:mm:ss"))

"select * from tb  where [DATETIME] > '"&datetime &"'" 

[forcyever]

http://bbs.csdn.net/topics/156532

[telankes2000]

已经解决 使用datetime 函数即可 创建新的时间类型 
注意字段千万不要画色添足给字段添加[] 即便字段名字和系统保留字冲突
datetime(2014,7,1,09,0,0) = 2014-07-01 09:00:00
select * from tb  where datetime> datetime(2014,7,1,09,0,0)

[伤逝的离别]

1,2,3,4提莫队长正在学习！