declare @am DATETIME ='2011-08-01 06:00:00'
declare @pm DATETIME ='2011-08-01 12:00:00'
declare @amend datetime
declare @pmend datetime
declare @end datetime ='2011-08-31 12:00:00'
while(@pm<@end)
begin
select * from 表名 where 时间字段 BETWEEN @am AND @pm
set @amend=DATEADD(d,1,@am);
set @am=@amend
set @pmend=DATEADD(d,1,@pm);
set @pm=@pmend
end
温馨提示:答案为网友推荐,仅供参考