一天内时钟分钟重复的时刻

DengXingJie

于 2011-02-25 20:56:00 发布

阅读量937

点赞数

文章标签： insert table n2

本文链接：https://blog.csdn.net/DengXingJie/article/details/6208586

版权

declare @TimeResult Table (sTime char(8)) 
declare    @nSecond int,
        @h int,
        @m int,
        @s int,
        @n int
select @nSecond=0, @h=0, @m=0, @s=0, @n=0

while @n<23
    begin
        set @nSecond=Round(720*60*@n/11.0, 0)
        set @h=@nSecond/60/60
        set @m=(@nSecond/60)%60
        set @s=@nSecond%60%60
        if @h<24
            insert into @TimeResult
            select sTime=Replicate('0', 2-len(@h))+Cast(@h as varchar(2))+':'
                        +Replicate('0', 2-len(@m))+Cast(@m as varchar(2))+':'
                        +Replicate('0', 2-len(@s))+Cast(@s as varchar(2))
        set @n=@n+1
    end

select * from @TimeResult