get first date of month in sql server code example

Example 1: sql server beginning of month

SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth

Example 2: get first monday of month sql

select DATEADD(wk, DATEDIFF(wk,0,
            dateadd(dd,6-datepart(day,getdate()),getdate())
                               ), 0)  
--Change getdate to your variable

Tags:

Sql Example

Related