declare @TimeStart datetime
declare @TimeTo datetime
...
set @TimeStart=dateadd(day,-datepart(day,@TimeStart),@TimeStart)
set @Timeto=dateadd(day,-datepart(day,@Timeto),dateadd(month,1,@Timeto))...
declare @TimeTo datetime
...
set @TimeStart=dateadd(day,-datepart(day,@TimeStart),@TimeStart)
set @Timeto=dateadd(day,-datepart(day,@Timeto),dateadd(month,1,@Timeto))...
如给出的范围是 2004-07-05 ---- 2004-07-20
select * from 表 wehere 日期字段>=给出范围的开始日期 and 日期字段<=给出范围的结束日期
in code: a,bsql: A<=b and B>=a