How to get first day of week

Posted by Suthahar on Friday, January 21, 2011 No comments

select DATEADD(DD, 1 - DATEPART(DW, getdate()),getdate())

Suthahar

Suthahar Jegatheesan is Mobile and Cloud Specialist/Architect and he has 15+ years of IT experience as a Technology Consultant /Programmer/Developer in IT industry. Suthahar is an industry luminary focused on AI, Computer Vision, Bot, Machine Learning, UWP, Azure, Xamarin and Web Emerging User Experiences as subject matter expert (SME) in implementation, architecture, development and administration.

About Suthahar →

Facebook

Twitter

Google+

Delicious