已知一个日期,求这个日期所在周的周一和周日的具体日期
declare @date smalldatetime,@dateStart smalldatetime,@dateEnd smalldatetime
set @date='2018-01-09'
set @dateStart=@date-(datepart(weekday,@date))+2
set @dateEnd=@dateStart+6
select @dateStart,@dateEnd
declare @date smalldatetime,@dateStart smalldatetime,@dateEnd smalldatetime
set @date='2018-01-09'
set @dateStart=@date-(datepart(weekday,@date))+2
set @dateEnd=@dateStart+6
select @dateStart,@dateEnd