SQL Get the last date of the month






2.60/5 (3 votes)
Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @Date))
Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @Date))
2.60/5 (3 votes)
Select dateadd(day, -1, dateadd(month, 1, dateadd(day, 1 - day(@Date), @Date))