Home Forums SQL Server 7,2000 T-SQL Week Ending Dates RE: Week Ending Dates
Kenneth Wilhelmsson
SSC-Dedicated
Points: 30043
More actions
March 3, 2005 at 8:06 am
#545230
set datefirst 1 -- start weeks on mondays
select datecolumn
from myTable
where datepart(dw, datecolumn) = 5
Have a look in BOL at DATEPART for further info on datefunctions.
/Kenneth