What is the equivalent of Oracle's LAST_DAY() function in SQL Server 2008? [duplicate]

Question

I have used the LAST_DAY() function in Oracle like this:

Last_Day( to_date( '$pay_first_day' , 'YYYY-mm-dd') )

What do i have to do in SQL server 2008 R2 database to achieve the same result?

Answer 1

Try this one -

DECLARE @Date DATETIME
SELECT @Date = GETDATE()

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, @Date) + 1, 0) - 1