取数据日期时间

#以下时间均为：20071130235959

# 5分钟
declare @time1 varchar(20),@time2 varchar(20)
# 当前时间减去5分钟
select @time1=replace(replace(replace(CONVERT(varchar, dateadd(mi,-5,getdate()), 120 ),'-',''),' ',''),':','') 
# 当前时间
select @time2=replace(replace(replace(CONVERT(varchar,dateadd(mi,-0,getdate()), 120 ),'-',''),' ',''),':','') 

select count(dOctets) from Raw_V5 where   stamp between @time1 and @time2

一天
#24小时统计,只要在晚上12点执行就可以统计当天的记录,
declare @time1 varchar(20),@time2 varchar(20)
#前一天 20071209000000
select @time1=replace(replace(replace(convert(varchar(18),(CONVERT(varchar(10), dateadd(mi,-1440,getdate()), 120 ))+'000000',120),'-',''),' ',''),':','') 
#前一天 20071209235959
select @time2=replace(replace(replace(convert(varchar(18),(CONVERT(varchar(10),dateadd(mi,-1440,getdate()), 120 ))+'235959',120),'-',''),' ',''),':','') 

select count(dOctets) from Raw_V5 where   stamp between @time1 and @time2


月份
#上一个月的第一天 20071101000000
select replace(replace(replace(CONVERT(varchar,CONVERT(datetime,CONVERT(char(8),dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)),120)+'1'), 120 ),'-',''),' ',''),':','')  
 
#上一个月的最后一天 20071130235959
select replace(replace(replace(CONVERT(varchar,dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)), 120 ),'-',''),' ',''),':','')