22,207
社区成员
发帖
与我相关
我的任务
分享
select * from tb where 时间列 between '2007-10-01' and '2008-10-1'
select * from tb
where dt>='2007-10-01' and dt<dateadd(dd,1,'2008-10-01')
select * from tb
where datediff(dd,'2007-10-01')=0
--或
select * from tb
where convert(varchar(10),dt,120)='2007-10-01'
select * from tb where 时间列 between '2007-10-01' and '2008-10-1'