declare @min intset @min = convert( int ,datepart(mi,getdate())) select case when @min - @min /15 *15 > (@min /15 +1) *15 - @min then (@min /15 +1) *15 else @min /15 *15 end
declare @d datetime set @d=getdate() select 当前时间=@d, 转换后的分钟=cast(round(datepart(mi,@d)/15.0,0)*15 as int), 转换后的时间=convert(varchar(14),@d,120)+replace(str(cast(round(datepart(mi,@d)/15.0,0)*15 as int),2),' ','0') +right(convert(varchar(100),@d,114),7)
select case when @min - @min /15 *15 > (@min /15 +1) *15 - @min then (@min /15 +1) *15
else @min /15 *15 end
set @d=getdate()
select 当前时间=@d,
转换后的分钟=cast(round(datepart(mi,@d)/15.0,0)*15 as int),
转换后的时间=convert(varchar(14),@d,120)+replace(str(cast(round(datepart(mi,@d)/15.0,0)*15 as int),2),' ','0')
+right(convert(varchar(100),@d,114),7)