C#操作语法错误（操作符丢失）在查询表达式‘OccurTimebetween2013-4-240:00:00and2013-4-2416:40C#操作access数据库,OccurTime是日期时间类型的,运行出现错误,操作语法错误（操作符丢失）在查询表

Question

C#操作语法错误 （操作符丢失）在查询表达式‘OccurTime between 2013-4-24 0:00:00 and 2013-4-24 16:40
C#操作access数据库,OccurTime 是日期时间类型的,运行出现错误,操作语法错误 （操作符丢失）在查询表达式‘OccurTime between 2013-4-24 0:00:00 and 2013-4-24 16:40,查询语句如下select * from Alarms where OccurTime between " + DateTime.Parse("2013-04-24 00:00:00") + " and " + DateTime.Parse("2013-04-24 16:40:00")

Answer 1

between '2013-4-24 0:00:00' and '2013-4-24 16:40' 时间两边加单引号,不用DateTime.Parse