declare @begintime as datetime declare @endtime as datetime declare @hour as int declare @min as int set @min = datepart(minute, getdate()) if @min 30 begin set @begintime = convert(varchar(10), getdate(), 120) + ' ' + cast(datepart(hour,
declare @begintime as datetime
declare @endtime as datetime
declare @hour as int
declare @min as int
set @min = datepart(minute, getdate())
if @min < 30
begin
set @begintime = convert(varchar(10), getdate(), 120) + ' ' + cast(datepart(hour, getdate()) as varchar) + ':30'
set @endtime = convert(varchar(10), getdate(), 120) + ' ' + cast(datepart(hour, getdate()) as varchar) + ':00'
set @begintime = dateadd(hour, -1, @begintime)
end
else
begin
set @begintime = convert(varchar(10), getdate(), 120) + ' ' + cast(datepart(hour, getdate()) as varchar) + ':00'
set @endtime = convert(varchar(10), getdate(), 120) + ' ' + cast(datepart(hour, getdate()) as varchar) + ':30'
end
exec up_genreport @begintime, @endtime
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！