Getting last day of the current month 1

[davman2002]

Hi all I am really new to SQL, I normally use VB and C++. I need to know how to find out the starting date of the current month and the ending date of the current month. I noticed that there is a DATEADD function however I did not find any usefull information regarding how to use it. Any help is apreciated.

Thanks

 

[Lftsk]

This should give you the Beginning of the current month

SELECT GETDATE() - DATEPART(d, GETDATE()) + 1

This should give you the ending date of the current month.

SELECT DATEADD(m, 1, GETDATE()) - DATEPART(d, DATEADD(m, 1, GETDATE()))