last_day function

[Chris]

There is a date function in Oracle called last_day, to return the last day of the month of the date expressed in the function. This function doesn't exist in T-SQL - does anyone have any tricks I can use to get the same result, or knows of a function that will do it for me?

[Phil Simms]

I admit this is a bit complicated looking but it works.

SELECT Convert(datetime, Convert(varchar(2), MONTH(DATEADD(MM, +1, Getdate()))) + '-' + Convert(varchar(2), DAY('01-dec-2000&#39) + '-' + Convert(varchar(4), YEAR(DATEADD(MM, +1, Getdate())))) -1

If you find something simpler please post it. I'd love to find something better myself.
------------
Chris at 4/11/2002 4:17:30 AM

There is a date function in Oracle called last_day, to return the last day of the month of the date expressed in the function. This function doesn't exist in T-SQL - does anyone have any tricks I can use to get the same result, or knows of a function that will do it for me?