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

Jak

Member

858 Points

132 Posts

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

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

Share:

Answers

Rahul M...

Teacher

4822 Points

23 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