////////////////// Sql script
declare @SelectdData varchar(10)='2019-03-04'
SELECT DATEADD(d,(9- DATEPART(dw,@SelectdData)),@SelectdData) StartDateOfWeek, DATEADD(d,6,(DATEADD(d,(9- DATEPART(dw,@SelectdData)),@SelectdData)))EndDataOfWeek
///////////////////Result
No comments:
Post a Comment