sqlserver每30分自动生成一次

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