计算两个日期完整时间差

【#文档大全网# 导语】以下是®文档大全网的小编为您整理的《计算两个日期完整时间差》，欢迎阅读！

Select Cast((Datediff(minute, '2013-01-01 12:34:56', Getdate()) / 1440) As Varchar) + '天' +

Cast(((Datediff(minute, '2013-01-01 12:34:56', Getdate()) % 1440) / 60) As Varchar) + '小时' +

Cast(((Datediff(minute, '2013-01-01 12:34:56', Getdate()) % 1440) % 60) As Varchar) + '分'

Select Cast((Datediff(second, '2013-01-01 12:34:56', Getdate()) / 86400) As Varchar) + '天' +

Cast(((Datediff(second, '2013-01-01 12:34:56', Getdate()) % 86400) / 3600) As Varchar) + '小时' +

Cast(((Datediff(second, '2013-01-01 12:34:56', Getdate()) % 86400 % 3600) / 60) As Varchar) + '分' +

Cast((((Datediff(second, '2013-01-01 12:34:56', Getdate()) % 86400 % 3600) % 60) % 60) As Varchar) + '秒'

本文来源：https://www.wddqxz.cn/1e4ecf11a417866fb84a8ecd.html