get last date of current, previous and next month in sql

Jak

908 Points

132 Posts

How to get last date of current, previous and next month in sql?

Views: 9197
Total Answered: 1
Total Marked As Answer: 1
Posted On: 23-Feb-2015 13:22

Share:

Answers

Rahul M...

4960 Points

31 Posts

Hi,

---Last Day of Previous Month

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

LastDay_PreviousMonth

----Last Day of Current Month

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))

LastDay_CurrentMonth

----Last Day of Next Month

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

LastDay_NextMonth

Posted On: 23-Feb-2015 13:24

Discussion

MVC Design pattern