在数据库中时间是以2006-11-27 16:04:25.390的形式存储的
如果我要查在2006-11-27这一天的信息
以where saledate between '2006-11-27' and '2006-11-27'为条件则查不出来
而以where saledate between '2006-11-27' and '2006-11-28'则查的出来
我的问题是
怎样能够使区间两端的日期相同而查出当天的信息
如果我要查在2006-11-27这一天的信息
以where saledate between '2006-11-27' and '2006-11-27'为条件则查不出来
而以where saledate between '2006-11-27' and '2006-11-28'则查的出来
我的问题是
怎样能够使区间两端的日期相同而查出当天的信息
where convert(char,saledate,111) between '2006-11-27' and '2006-11-27'
where convert(varchar(10),saledate,20)='2006-11-27'可以吧
实在不行用datepart也可以,where datepart(y,saledate)='2006' and datepart(m,saledate)='11' and datepart(d,saledate)='27'
所以where saledate between '2006-11-27' and '2006-11-27'
等于
where saledate between '2006-11-27 00:00:00' and '2006-11-27 00:00:00'
或
where convert(varchar(10),saledate,120)='2006-11-27'
等等
where convert(varchar(10) , saledate , 121 ) between '2006-11-27' and '2006-11-27'