如何计算两个日期之间的星期天? [英] How can i count sunday between 2 dates?

问题描述

大家好，

我怎样才能在2个日期之间只获得星期日?

谢谢

TONY

Hi all,

How can i get only Sunday between 2 dates?

Thanks

TONY

推荐答案

declare @DateFrom DateTime ='2012-07-15',
            @DateTo DateTime = '2012-08-05'
;WITH CTE(totaldays)
AS
(
      Select @DateFrom
      Union All
      Select DATEADD(d,1,totaldays)FROM CTE
      Where totaldays<@DateTo
)
select count(1) from CTE
where DATENAME(dw,totaldays)In('Sunday')

declare @DateFrom DateTime ='2012-07-15',
            @DateTo DateTime = '2012-08-05'
;WITH CTE(totaldays)
AS
(
      Select @DateFrom
      Union All
      Select DATEADD(d,1,totaldays)FROM CTE
      Where totaldays<@DateTo
)
select totaldays from CTE
where DATENAME(dw,totaldays)In('Sunday')

declare @startdate datetime, @enddate datetime
set @startdate = '08/01/2012'
set @enddate = '08/20/2012'
declare @numberOfSundays int
set @numberOfSundays = 0
set @enddate = dateadd(d, -1, @enddate)
while @startdate <= @enddate
begin
        if datename(weekday, @startdate) = 'Sunday'
        begin
                set @numberOfSundays = @numberOfSundays + 1
        end
        set @startdate = dateadd(d, 1, @startdate)
end
select @numberOfSundays

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