查找两个日期之间的日期差 [英] Find Date Difference between two dates

问题描述

朋友们，
如何找到两个日期之间的日期差异?
我想要这样的差异:d(天):HH(小时):MM(分钟)
我有两个日期列，并希望以给定格式获得它们之间的区别.
我使用sql server 2008
任何帮助将不胜感激.
问候，
Lok ..

Hi friends,
How do we find date diffrence between two dates?
I want difference like this : d(days):HH(hours):MM(Mins)
I have two date columns and want to get difference between them in the given format.
I use sql server 2008
Any help will be appreciated.
Regards,
Lok..

推荐答案

谢谢您的提问，

Thank you for your question,

DECLARE @StartDate datetime
DECLARE @EndDate datetime

SELECT @StartDate=Date1 FROM MyDate
SELECT @EndDate=Date2 FROM MyDate

SELECT CONVERT(VARCHAR(2),ABS(DATEDIFF(dd,@StartDate,@EndDate)))
+' ' +
CONVERT(VARCHAR(2),ABS(DATEDIFF(hh,@StartDate,@EndDate)))
+' ' +
CONVERT(VARCHAR(2),ABS(DATEDIFF(MM,@StartDate,@EndDate)))

谢谢，
Mamun

Thanks,
Mamun

您可以使用以下代码找到BDate和JDate之间的区别
CONVERT(nvarchar, DATEDIFF(d, BDate, JDate)) + '':'' + CONVERT(nvarchar, DATEDIFF(hh, BDate, JDate) % 24) + '':'' + CONVERT(nvarchar, DATEDIFF(n, BDate, JDate) % 60)

You can use following to find difference between BDate and JDate
CONVERT(nvarchar, DATEDIFF(d, BDate, JDate)) + '':'' + CONVERT(nvarchar, DATEDIFF(hh, BDate, JDate) % 24) + '':'' + CONVERT(nvarchar, DATEDIFF(n, BDate, JDate) % 60)

SELECT
    ID, 
    Name, 
    BDate, 
    JDate, 
    CONVERT(nvarchar, DATEDIFF(d, BDate, JDate)) + ':' + CONVERT(nvarchar, DATEDIFF(hh, BDate, JDate) % 24) + ':' + CONVERT(nvarchar, DATEDIFF(n, BDate, JDate) % 60) AS Difference
FROM
    Temp

请检查以下各项:

http://www.sqlservercurry.com/2008/04/find-hours-minutes-and-seconds-in.html[

Please check the following:

http://www.sqlservercurry.com/2008/04/find-hours-minutes-and-seconds-in.html[^]

这篇关于查找两个日期之间的日期差的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！