“时间类型”的“查询”不能这样用吗???select * from WarnUseEnergy where MeterNo in ('YD1202','YD1207','YD1205','YD1206') and DATime between '2012-11-19 00:00:00.000' and '2012-11-19 59:59:99.999'
提示错误:The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 要查询“DATime”为“2012-11-19”的全天的数据,怎么回事呢,大师??? 应该如何修正???
提示错误:The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 要查询“DATime”为“2012-11-19”的全天的数据,怎么回事呢,大师??? 应该如何修正???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货