How to get week start date of particular date in SQL Server?

Question

'10/10/2018' is the given date, I want to find week start date in which this date falls..according to calendar

Start of the week depends on the culture. also is this field a date derivative, also you tagged C# what role does C# play in this, also you have shown no code, no research, and no problem as such — TheGeneral, Mar 05 '19 at 04:41

PSK · Answer 1 · 2019-03-05T04:49:06.377

You can get the first day of the week like following.

 declare @inputdate date='10/10/2018'
 select DATEADD(dd, -(DATEPART(dw, @inputdate)-1), @inputdate) [WeekStart]

If you want to change the first day of week to a specific day, for this you can use SET DATEFIRST

SET DATEFIRST 7
declare @inputdate date='10/10/2018'
select DATEADD(dd, -(DATEPART(dw, @inputdate)-1), @inputdate) [WeekStart]

score 0 · Answer 2 · answered Mar 05 '19 at 04:43

0

You can try below -

select DATEADD(dd, -(DATEPART(dw, '10/10/2018)-1), '10/10/2018)

answered Mar 05 '19 at 04:43

Fahmi

score 0 · Answer 3 · edited Mar 05 '19 at 05:26

0

Please try this query:

SELECT DATEADD(DAY, 2 - DATEPART(WEEKDAY, '10/10/2018' ), CAST('10/10/2018' AS DATE)) [Week_Start_Date]

edited Mar 05 '19 at 05:26

answered Mar 05 '19 at 04:48

Hemang A

3 Answers3