To get the Monday date of the current week you can use the snippet below.
SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) AS Monday
4 thought on “How to get monday date of current week in MSSQL”
Leave a Reply
You must be logged in to post a comment.
All the Code Snippets and Samples you need
To get the Monday date of the current week you can use the snippet below.
SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) AS Monday
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to get monday date of current week in #MSSQL http://t.co/iepeToeKhi #sql #tsql #sqlserver #coding #code #dev #deve…
RT @CodeSnippetsNET: How to get monday date of current week in #MSSQL http://t.co/iepeToeKhi #sql #tsql #sqlserver #coding #code #dev #deve…
RT @CodeSnippetsNET: How to get monday date of current week in #MSSQL http://t.co/iepeToeKhi #sql #tsql #sqlserver #coding #code #dev #deve…
RT @CodeSnippetsNET: How to get monday date of current week in #MSSQL http://t.co/iepeToeKhi #sql #tsql #sqlserver #coding #code #dev #deve…