Exists this Date Function? 2

[RovirozM]

Hi Guys,

Do you know if there's a function that give me this information?

If I have the Date of today ( For example Getdate() ) depending of that day can I know the first day of the actual month and the last one with a function?

For example I have this: 2-Jun-2010

And I Will know this:
FirstDayMonth: 1-Jun-2010
LastDateMonth: 30-Jun-2010

Thanks!

 

[RiverGuy]

Run this code:

DECLARE @Today DATETIME
SELECT @Today = CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 112))

SELECT @Today AS Today, DATEADD(day, (DATEPART(day, @Today) - 1) * -1, @Today) AS FirstDayOfMonth, DATEADD(day, -1, DATEADD(month, 1, DATEADD(day, (DATEPART(day, @Today) - 1) * -1, @Today))) AS LastDayOfMonth

 

[markros]

Take a look at

http://wiki.lessthandot.com/index.php/How_to_find_the_first_and_last_days_in_years,_months_etc

PluralSight Learning Library