Select  convert( datetime,replace(str(year(dateadd("m", 1, Getdate())), 4), ' ', '0') + replace(str(month(dateadd("m", 1, Getdate())), 2), ' ', '0') + '01',112)-1 as LastDayThisMonth can also work for the same.

Cheers,

Manoj