First Day of a Month

Posted by Kirthiga under Sql Server category on 5/21/2013 | Points: 40 | Views : 1539

Declare @FirstDay datetime='2013-02-25'
select DATEADD(MM,DATEDIFF(MM,0,@FirstDay),0) [FirstDay Of a Month]

Bookmark It

Posted by: Pandians on: 5/22/2013 Level:Silver | Status: [Member] [MVP] | Points: 10

In Another way!

Declare @FirstDay datetime='2013-02-25'

SELECT @FirstDay - DAY(@FirstDay)+1

Latest Code Snipptes