try:select *
from table1
where datediff(day,'2005-6-1 00:00:00',[date])>=0
and datediff(day,[date],'2005-7-1 00:00:00')<=0
from table1
where datediff(day,'2005-6-1 00:00:00',[date])>=0
and datediff(day,[date],'2005-7-1 00:00:00')<=0
select * from table where convert(char,data,102)>'2005.06.01' and convert(char,data,102)<'2005.07.01'
不知道这样对不对哦。。高手看一下。我感觉时间节点是不是有点不对!