Find the first Day (01) and the Last Day (28) for a specified month in SQL Function?

[Fahhad]

I need to write an SQL Function (UDF) to find the First Day (int) and the Last Day (int) when I specify a date.

For example: When I specify (20130217) (i.e. Feb 17th, 2013), I should be able to find the First Day (01) and the Last Day (28) for the specified month (in this case, Feb).

How can I do that? Please provide the necessary code to implement this feature in my SQL Function.

Thanks.

[Rabbit]

This is not a code writing service but if you post the code you've tried along with a description of the problem you're having with the code, we can help guide you to a solution.

As a hint, you can use the various date functions combined with cast functions to build the dates you need.

[ck9663]

I think he's just asking for a straight forward function to get the first and last day of the month.


Here, find your dates here.

Happy Coding!!!


~~ CK

[swathee]

DECLARE @yourDate DATETIME
SET @yourDate = '2013-02-17'

SELECT DAY(DATEADD(MONTH, DATEDIFF(MONTH, 0, @yourDate), 0)) AS First,
       DAY(DATEADD(MONTH, DATEDIFF(MONTH, -1, @yourDate), -1)) AS Last