update FSVZ_DataInformation set IsPrint = 1 where convert(varchar(16),Acctime,120) between convert(varchar(16),beginDate,120) and convert(varchar(16),endDate,120)数据库中Acctime值为2009-08-18 00:00:00.000
beginDate 为 "2009-8-18 0:00:00"
endDate 为"2009-8-18 0:15:00"为什么修改不了 大家看看出题出在哪里 谢谢
我想修改的值为 2009-08-18 00:00:00.000=< zhi <=009-08-18 00:15:00.000
beginDate 为 "2009-8-18 0:00:00"
endDate 为"2009-8-18 0:15:00"为什么修改不了 大家看看出题出在哪里 谢谢
我想修改的值为 2009-08-18 00:00:00.000=< zhi <=009-08-18 00:15:00.000
select * from FSVZ_DataInformation
where convert(varchar(16),Acctime,120) between convert(varchar(16),beginDate,120) and convert(varchar(16),endDate,120)
select * from FSVZ_DataInformation
where convert(varchar(16),Acctime,120) between convert(varchar(16),'2009-08-18 00:00',120) and convert(varchar(16),'2009-08-18 00:15',120)
可以查询到相应的值
beginDate 为 "2009-8-18 0:00:00"
endDate 为"2009-8-18 0:15:00" 红色部分造成的问题 怎么去修改 大家帮忙