34,576
社区成员
发帖
与我相关
我的任务
分享
DECLARE @date1 datetime
DECLARE @date2 datetime
DECLARE @dateDiff datetime
SET @date1 = Convert(datetime,'2000-01-23 04:56:07',120)
SET @date2 = GetDate()
SET @dateDiff = @date2 - @date1
SELECT @date1 AS [From],
@date2 AS [To],
Convert(varchar(11), Year(@dateDiff)-1900) + '年' +
Convert(varchar(11), Month(@dateDiff)) + '月' +
Convert(varchar(11), Day(@dateDiff)) + '天 ' +
Convert(varchar(8), @dateDiff, 114) AS [Diff]
From To Diff
----------------------- ----------------------- ------------------------------------------------
2000-01-23 04:56:07.000 2014-10-20 13:32:09.050 14年9月29天 08:36:02