还可以: DECLARE @x int SET @x=3660 SELECT CAST(@x/3600 as varchar(2)) +':'+CAST(@x/60%60 as varchar(2))+':'+CAST(@x%60 as varchar(2))SET @x=72 SELECT CAST(@x/3600 as varchar(2)) +':'+CAST(@x/60%60 as varchar(2))+':'+CAST(@x%60 as varchar(2))
declare @ss varchar(20),@m int select @ss='',@m = 12345678 if @m/(60*60*24) >0 set @ss = @ss + rtrim(@m/(60*60*24))+' ' set @m = @m%(60*60*24) set @ss = @ss + rtrim(@m/(60*60))+':' set @m = @m%(60*60) set @ss = @ss +rtrim(@m/60)+':' set @m = @M%60 set @ss = @ss +rtrim(@m) select @ss--142 21:21:18
declare @ss varchar(20),@m int select @ss='',@m = 12345678 if @m/(60*60*24) >0 set @ss = @ss + rtrim(@m/(60*60*24))+' ' set @m = @m%(60*60*24) set @ss = @ss + case len(@m/(60*60)) when 1 then '0' else '' end+rtrim(@m/(60*60))+':' set @m = @m%(60*60) set @ss = @ss+case len(@m/(60*60)) when 1 then '0' else '' end +rtrim(@m/60)+':' set @m = @M%60 set @ss = @ss +case len(@m/(60*60)) when 1 then '0' else '' end+rtrim(@m) select @ss--142 21:21:18
------------------------------------------------------
2008-01-29 00:01:12.000(所影响的行数为 1 行)
/*
--------
00:01:12(所影响的行数为 1 行)
*/
/*
--------
00:01:12(所影响的行数为 1 行)
*/
set @dt=''
select dateadd(ss,72,@dt)1900-01-01 00:01:12.000
/*
--------
00:01:12(所影响的行数为 1 行)
*/
DECLARE @x int
SET @x=3660
SELECT CAST(@x/3600 as varchar(2)) +':'+CAST(@x/60%60 as varchar(2))+':'+CAST(@x%60 as varchar(2))SET @x=72
SELECT CAST(@x/3600 as varchar(2)) +':'+CAST(@x/60%60 as varchar(2))+':'+CAST(@x%60 as varchar(2))
Select DATEADD(s, 72, '00:00:00')
--結果:1900-01-01 00:01:12.000
Select CONVERT(varchar(20), DATEADD(s, 72, '00:00:00'), 120)
--結果:1900-01-01 00:01:12
Select SUBSTRING(CONVERT(varchar(20), DATEADD(s, 72, '00:00:00'), 120), 12, 8)
--結果:00:01:12
------------------------------
00:01:12:000(所影响的行数为 1 行)
set @s=72
select right(convert(char(19),dateadd(ss,@s,'1900-1-1 00:00:00'),120),8)
select convert(varchar(8),dateadd(ss,72,'00:00:00'),108)/*
结果:
00:01:12*/
declare @ss varchar(20),@m int
select @ss='',@m = 12345678
if @m/(60*60*24) >0 set @ss = @ss + rtrim(@m/(60*60*24))+' '
set @m = @m%(60*60*24)
set @ss = @ss + rtrim(@m/(60*60))+':'
set @m = @m%(60*60)
set @ss = @ss +rtrim(@m/60)+':'
set @m = @M%60
set @ss = @ss +rtrim(@m)
select @ss--142 21:21:18
select @ss='',@m = 12345678
if @m/(60*60*24) >0 set @ss = @ss + rtrim(@m/(60*60*24))+' '
set @m = @m%(60*60*24)
set @ss = @ss + case len(@m/(60*60)) when 1 then '0' else '' end+rtrim(@m/(60*60))+':'
set @m = @m%(60*60)
set @ss = @ss+case len(@m/(60*60)) when 1 then '0' else '' end +rtrim(@m/60)+':'
set @m = @M%60
set @ss = @ss +case len(@m/(60*60)) when 1 then '0' else '' end+rtrim(@m)
select @ss--142 21:21:18
---------------
00:01:12