在两个日期之间获得五天组 [英] Get Group of Five Days between Two dates
问题描述
我想要通过两个日期的结果如下;
01-11-2013至05-11-2015    06-11-2013至11-11-2013 Coloumns
5                                                  6                                  数据
您好,请考虑使用 DATEDIFF [ ^ ]
例如:
SELECT DATEDIFF( dd,CAST(' 2013-11-01' AS DATE ),CAST(' 2013- 11-05' AS DATE ))
但此条款将返回4,此日期对不是5。
尝试此查询: -
SELECT DATEDIFF(d,CAST('2013-11-01'AS datetime),CAST('2013-11-05'AS datetime)),DATEDIFF(d,CAST('2013-11-06 'AS datetime),CAST( 2013-11-12'AS datetime))
O / p: -
4,5
i want result like following on passing two date ;
01-11-2013 to 05-11-2015 06-11-2013 to 11-11-2013 Coloumns
5 6 Data
Hello, consider to use DATEDIFF[^]
For example:
SELECT DATEDIFF(dd, CAST('2013-11-01' AS DATE), CAST('2013-11-05' AS DATE))
But this clause will return 4 for this dates pair not 5.
try this query :-
SELECT DATEDIFF(d, CAST('2013-11-01' AS datetime), CAST('2013-11-05' AS datetime)) ,DATEDIFF(d, CAST('2013-11-06' AS datetime), CAST('2013-11-12' AS datetime))
O/p:-
4 ,5
这篇关于在两个日期之间获得五天组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!