[dba-SQLServer] Current Week in SQL

Darren DICK darrend at nimble.com.au
Sun Jun 18 22:03:43 CDT 2006


Hi all
 
Is there an easy way to determine the date of the Monday in the current week -
Also the same for the Sunday of the current week?
 
E.g. - Assume today is Wednesday the 3rd April
 
I need help to determine that Monday is the 1st April 2006 and Sunday would be
the 7th April
 
Just need to work our the Monday date and Sunday date of any week we are in
 
Make sense?
 
Many thanks
 
Have a great day
 
Darren
 



More information about the dba-SQLServer mailing list