convert(varchar(50),要转换的内容)
拼接直接 用+''即可
例子:
convert(varchar(50),datediff(second,HEARTTIME,GETDATE())/86400)+':'+convert(varchar(50),datediff(second,HEARTTIME,GETDATE())%86400/3600)+':'+convert(varchar(50),datediff(second,HEARTTIME,GETDATE())%86400%3600/60),