SQL SERVER – Find Monday of the Current Week

Very Simple Script which find Monday of the Current Week

SELECT
DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) MondayOfCurrentWeek

Reference : Pinal Dave (https://darkslategrey-bat-805937.hostingersite.com)

SQL DateTime, SQL Scripts, SQL Utility
Previous Post
SQLAuthority News – Book Review – Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
Next Post
SQLAuthority News – Principles of Simplicity

Related Posts

Leave a Reply