how to get sunday date for a month

Question

im using SQL server 12 I don't no how to select Sunday date for a month ex.if month is march means Sunday dates are 05-03-17 12-03-17 like that

Rajeev Punhani · Answer

Hi Siva  Please try the below declare @d datetime select @d = getdate(); select dateadd(ddnumber@d) from master..spt_values where type = 'p' and YEAR (dateadd(ddnumber@d))= year (@d) and month (dateadd(ddnumber@d))= month (@d) and DATEPART(dwdateadd(ddnumber@d)) = 1