例如：
select sum(value) from jxc
where Convert(char(10),Sdate,120) between '2010-7-26'
and '2010-8-25'
结果为NULL 也就是说现在要判断‘2010-07-29’是否在between '2010-7-26' and '2010-8-25' 之间
技穷了！请多指教
select sum(value) from jxc
where Convert(char(10),Sdate,120) between '2010-07-26'
and '2010-08-25'
结果为202.12
------解决方案--------------------
- SQL code
declare @t1 varchar(10)set @t1='2010-7-26'select convert(varchar(10),cast(@t1 as datetime),120)/*2010-07-26*/
------解决方案--------------------
- SQL code
select sum(value) from jxcwhere Convert(varchar(10),Sdate,120) between convert(varchar(10),cast('2010-7-26' as datetime),120) and convert(varchar(10),cast('2010-8-25' as datetime),120)