sql server中把秒数转化为时间差:
declare @seconds int=120;
select case when @seconds/86400<>0 then convert(nvarchar,@seconds/86400)+'天' else '' end
+convert(nvarchar,dateadd(s,@seconds%86400,0),108)
sql server中把秒数转化为时间差:
declare @seconds int=120;
select case when @seconds/86400<>0 then convert(nvarchar,@seconds/86400)+'天' else '' end
+convert(nvarchar,dateadd(s,@seconds%86400,0),108)