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.wddqw.com/doc/1e4ecf11a417866fb84a8ecd.html
正在阅读：
计算两个日期完整时间差01-01
假01-01
黄鹤楼01-01
日语作文01-01
l怎么读gun01-01
提公因式法分解因式的常用技巧01-01
男女之间的爱情怎样才叫合适？01-01
男人喜欢什么样的女人作为老婆01-01
考研人大专业介绍之考古学01-01