递归时间计算 [英] recursive time calculating

问题描述

我想输入一个时间到sql server数据库并开始以递归形式计算时间
例如输入时间05:23:34并开始计算直到00:00:00
有人帮我吗?

I wanna to enter a time to the sql server database and begin calculating the time in recursive form
for example entering the time 05:23:34 and start computing until 00:00:00
someone help me please ?

推荐答案

DECLARE @timeval AS DateTime
SET @timeval ='05:23:34'
DECLARE @Timetbl as table (tmval  datetime)

While @timeval <>'00:00:00'
 Begin
   INSERT INTO @Timetbl
   SELECT @timeval
   SET @timeval=DateAdd(ss,-1,@timeval)
 End

   INSERT INTO @Timetbl
   SELECT @timeval

select * from @Timetbl

这篇关于递归时间计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！