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
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
，