例如:
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
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
'2010-7-26' and '2010-8-25' 也是从表字段中取出来的
declare @t1 varchar(10)
set @t1='2010-7-26'
select convert(varchar(10),cast(@t1 as datetime),120)
/*
2010-07-26
*/
select sum(value) from jxc
where 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)
declare @t1 varchar(10)
set @t1='2010-7-26'
select convert(varchar(10),cast(@t1 as datetime),120)
成功,非常感谢