Q.How to find date of Holiday in Sql Server?

declare @fromdate datetime
declare  @todate datetime
select @fromdate = '2018-04-01',@todate= '2018-04-30'

;with dates ( date )
as
(
select @fromdate
union all
select dateadd(d,1,date)
from dates
where date < @todate
)
select DAY(CONVERT(VARCHAR(10),date,111)) from dates where datename(dw,date) = 'Sunday'