Select * from tb_Weight where Weight_DateTime >= '2012-07-03 13:11:43' and Weight_DateTime <= '2012-07-03 16:11:43' 报错:标准表达式中的类型不匹配。Select * from tb_Weight where Weight_DateTime between #2012-07-03 13:11:43# and #2012-07-03 16:11:43# 报错:不正常地定义参数对象。提供了不一致或不完成的信息。Select * from tb_Weight where Weight_DateTime >= '2012-07-03 13:11:43' and Weight_DateTime <= '2012-07-03 16:11:43' 报错与第一个的相同。
Weight_DateTime 是DateTime类型的。
Select * from tb_Weight where Weight_DateTime >= #2012-07-03# and Weight_DateTime <= #2012-07-03# 试试看
Weight_DateTime >= '2012-07-03 13:11:43' and Weight_DateTime <= '2012-07-03 16:11:43'
报错:标准表达式中的类型不匹配。Select * from tb_Weight where
Weight_DateTime between #2012-07-03 13:11:43# and #2012-07-03 16:11:43#
报错:不正常地定义参数对象。提供了不一致或不完成的信息。Select * from tb_Weight where
Weight_DateTime >= '2012-07-03 13:11:43' and Weight_DateTime <= '2012-07-03 16:11:43'
报错与第一个的相同。
Weight_DateTime >= #2012-07-03# and Weight_DateTime <= #2012-07-03#
试试看